Page 544 - Excel 2013 All-in-One For Dummies

526 Worksheet Charting 101
Figure 1-7:
The clustered column chart after switching the columns and rows.
Editing the source of the data graphed in the chart
When you click the Select Data command button on the Design tab of the Chart Tools contextual tab (or press Alt+JCE), Excel opens a Select Data Source dialog box similar to the one shown in Figure 1-8. The controls in this dialog box enable you to make the following changes to the source data:
✦ Modify the range of data being graphed in the chart by clicking the Chart Data Range text box and then making a new cell selection in the work- sheet or typing in its range address.
✦ Switch the row and column headings back and forth by clicking its Switch Row/Column button.
✦ Edit the labels used to identify the data series in the legend or on the horizontal (category) by clicking the Edit button on the Legend Entries (Series) or Horizontal (Categories) Axis Labels side and then selecting the cell range with appropriate row or column headings in the work- sheet.
✦ Add additional data series to the chart by clicking the Add button on the Legend Entries (Series) side and then selecting the cell containing the heading for that series in the Series Name text box and the cells contain- ing the values to be graphed in that series in the Series Values text box.
✦ Delete a label from the legend by clicking its name in the Legend Entries (Series) list box and then clicking the Remove button.