Microsoft Office Tutorials and References
In Depth Information
Deleting a Chart Series
Deleting a Chart Series
The easiest way to delete a series from a chart is to select the series and press Delete.
Deleting the only series in a chart does not delete the chart. Rather, it gives you an
empty chart. If you’d like to delete this empty chart, just press Delete a second time.
Note
You can also use the Select Data Source dialog box to delete a series. Choose Chart Tools➜Design➜
Data➜Select Data to display this dialog box. Then select the series from the list and click the Remove
button.
Modifying the Data Range
for a Chart Series
After you’ve created a chart, you may want to modify the data ranges used by the chart. For example,
you may need to expand the range to include new data. Or you might need to substitute an entirely
different range. Excel offers a number of ways to perform these operations:
➤ Drag the range highlights.
➤ Use the Select Data Source dialog box.
➤ Edit the SERIES formula.
Each of these techniques is described in the following sections.
If you create your chart from data in a table (created by choosing Insert Tables
Table), the chart will adjust automatically if you add new data to the table.
Tip
Using range highlighting to change series data
When you select a series in a chart, Excel highlights the worksheet ranges used in that series. This
range highlighting consists of a colored outline around each range used by the series. Figure 6-4
shows an example in which the chart series (Region 1) is selected. Excel highlights the following
ranges:
➤ C2 (the series name)
➤ B3:B8 (the category labels)
➤ C3:C8 (the values)
Search JabSto ::




Custom Search