Replacing or Reordering Data Series in a Chart
When you add, remove, or reorder data in a chart, your changes don’t affect the table
or tables whose data is shown in the chart.
For example, if you want to replace a series of data values in an existing chart with a
different data series, you can easily replace any referenced row or column data used
in the chart with data from a different row or column, affecting only the chart, while
leaving all your tables intact. You can also change the order in which the data series
appear in the chart, without having to change your chart.
To reorder or replace a data series:
1
Select the chart.
A dark frame appears around the data cells in the table that are used in the chart.
2
Click the Inspector button in the toolbar, and then click the Chart button in the
Inspector window.
3
Click Series in the Chart inspector, and then do any of the following:
To change the order in which the series are displayed in the chart, select one of the
Â
series elements that you want to move, and then select a number from the Order
pop-up menu in the Series pane of the Chart inspector.
To replace all or part of a data series with a different row or column of data, in the
Â
Data field of the Series pane, select the cell reference representing the data series
range that you want to replace, and then drag across the new range of cells with
data that you want to include.
To change the data series label, in the Label field of the Series pane, select the cell
Â
reference containing the series label, and then select the cell with the label you
want to use.