Microsoft Office Tutorials and References
In Depth Information
Deleting a Chart Series
Modifying chart source data by using the range highlights is probably the simplest method. Note,
however, that this technique works only with embedded charts (not with chart sheets). In addition, it
doesn’t work when the chart’s data is in a worksheet other than the sheet that contains the
A surface chart is a special case. You cannot select an individual series in a surface chart.
But when you select the plot area of a surface chart, Excel highlights all the data used in
the chart. You can then use the range highlighting to change the ranges used in the chart.
Using the Select Data Source dialog
box to change series data
Another method of modifying a series data range is to use the Select Data Source dialog box. Select
your chart and then choose Chart Tools➜Design➜Data@>Select Data. Figure 6-6 shows the Select
Data Source dialog box.
Figure 6-6: The Select Data Source dialog box.
Notice that the Select Data Source dialog box has three parts:
➤ The top part of the dialog box shows the entire data range used by the chart. You can
change this range by selecting new data.
➤ The lower-left part displays a list of each series. Select a series and click the Edit button to
display the Edit Series dialog box to change the data used by a single series.
➤ The lower-right part displays the category axis labels. Click the Edit button to display the Axis
Labels dialog box to change the range used as the axis labels.
The Edit Series dialog box can vary somewhat, depending on the chart type. The Edit
Series dialog box for a bubble chart, for example, has four range selector controls: Series
Name, Series X Values, Series Y Values, and Series Bubble Size.