Intro

 

If necessary, you can also modify the way data is represented in a chart by:

•Changing the chart type (using the Change Chart Type button on the Type group on the Chart Tools Design tab).
•Changing the chart data (using the Switch Row/Column or Select Data button on the Type group on the Chart Tools Design tab).
•Changing the chart layout (using the buttons on the Chart Layouts group on the Chart Tools Design tab).
•Changing the chart styles (using the buttons on the Chart Styles group on the Chart Tools Design tab).

Type, Data, Chart Layouts, and Chart Styles Groups on the Chart Tools Design Tab

 
Changing Chart Data​

After creating a chart in Excel 2010, you may need to change the range of the source data that is the basis for the chart. The Select Data Source dialog box enables you to choose a different source range for an existing chart. You also can use this dialog box to switch the row and column values, change the order of the data series used in the chart, and indicate how to deal with hidden and empty cells in the data range being charted.

Reflection activity
•Which features allows you switch the vertical and horizontal axis?

Deleting Chart Data Series

Many components make up a chart. Each range of data that comprises a bar, column, or pie slice is called a data series; each value in a data series is called a data point. The data series is defined when you select a range on a worksheet and then open the Chart Wizard. But what if you want to add a data series once a chart is complete? Using Excel, you can add a data series by using the Design tab under Chart Tools, or using the mouse. As you create and modify more charts, you might also find it necessary to delete or change the order of one or more data series. You can delete a data series without re-creating the chart.

Reflection activity
•Explain the procedure to delete a chart data series.

​

​Delete, Move and Resize a Chart
•To select an existing chart, click on its border, or click in an empty space inside the chart. When selecting a chart, be careful not to click on an element inside the chart or that element will be selected instead.
• To delete a chart that has just been created, click the Excel Undo button. To delete an existing chart, select the chart and press the Delete key, or right-click and select Cut.
•To move a chart to a different place on the worksheet, select the chart and drag it to the desired location.
•To move a chart to a new or different spreadsheet in the same workbook, select the chart, right-click, and select Move Chart. Then choose the sheet or type in a new sheet name, and click OK.
•To resize a chart, select the chart and drag any of the chart's corners.

 
Reflexion activity
•Write two benefits of moving a chart to a new sheet.