Microsoft Office Tutorials and References
In Depth Information
Redefining the Data Range
The preceding steps work well if the range that you want to include is contiguous, but what
if you wanted to exclude a row or column that is in the middle of the range? To deﬁ ne the
range more precisely, follow these steps:
1. On the Chart Tools Design tab, click Select Data. The Select Data Source dia-
log box opens, shown in Figure 12.8, along with the Excel datasheet if it was not
To i ne-tune the data ranges, you can use the Select Data Source dialog box.
2. Do any of the following:
To remove a series, select it from the Legend Entries (Series) list and click
To add a series, click Add, and then drag across the range on the datasheet to
enter it into the Edit Series dialog box; then click OK to accept it.
To edit a series, select it in the Legend Entries (Series) list and click Edit. Then
drag across the range or make a change in the Edit Series dialog box, and click OK.
3. (Optional) To redefine the range from which to pull the horizontal axis labels,
click the Edit button in the Horizontal (Category) Axis Labels section. A dotted
outline appears around the current range; drag to redeﬁ ne that range and click OK.
4. (Optional) To redefine how empty or hidden cells should be treated, click the
Hidden and Empty Cells button. In the Hidden and Empty Cell Settings dialog
box that appears, choose whether to show data in hidden rows and columns and
whether to deﬁ ne empty cells as gaps in the chart or as zero values. Then click OK.
The Hidden and Empty Cells Settings dialog box is shown in Figure 12.9.