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

✦ Modify the order of the data series in the chart by clicking the series name in the Legend Entries (Series) list box and then clicking the Move Up button (the one with the arrow pointing upward) or the Move Down button (the one with the arrow pointing downward) until the data series appears in the desired position in the chart.
✦ Indicate how to deal with empty cells in the data range being graphed
by clicking the Hidden and Empty Cells button and then selecting the appropriate Show Empty Cells As option button (Gaps, the default; Zero and Span with Line, for line charts). Click the Show Data in Hidden Rows and Columns check box to have Excel graph data in the hidden rows and columns within the selected chart data range.
Using the Select Data Source dialog box
to remove the empty CD Sales label from the legend of the clustered column chart.
Worksheet Charting 101 527
Figure 1-8:
The example clustered column chart in Figures 1-6 and 1-7 illustrates a common situation where you need to use the options in the Source Data Source dialog box. The worksheet data range for this chart, A2:Q7, includes the CD Sales row heading in cell A3 that is essentially a heading for an empty row (E3:Q3). As a result, Excel includes this empty row as the first data series in the clustered column chart. However, because this row has no values in it (the heading is intended only to differentiate the CD sales from the cassette sales in the data table), its cluster has no data bars (columns) in it — a fact that becomes quite apparent when you switch the column and row headings, as shown earlier in Figure 1-7.
To remove this empty data series from the clustered column chart, you follow these steps:
1. Click the embedded chart to select it and then click the Select Data command button on the Design tab of the Chart Tools contextual tab.
Excel opens the Select Data Source dialog box similar to the one shown in Figure 1-8.
Book V Chapter 1
Charting Worksheet Data