Apple Numbers '09 - Manual (Page 142)

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.
Removing Data from a Chart
You can delete values from only a chart, leaving them in the related table, or you can
delete values from both a chart and its related table.
Here are ways to remove data:
To remove a data point from both a chart and the table where it appears, select the
m
cell in which the data resides, and then press Delete. The value is removed from the
table and the chart.
If you delete a column or row that is part of a two-column pair plotted in a scatter
chart, the related two-value data point is removed from the chart.
To remove multiple individual cell values from both a chart and the table where it
m
appears, select the table, hold down the Shift (for contiguous cells) or Command (for
noncontiguous cells) keys as you click to select the cells, and then press Delete. The
values are removed from both the table and the chart.
To shrink a contiguous range of cells comprising a chart, select the chart. In the table,
m
drag the circular control in the lower right of the range up or to the left. The cells
that are deselected are no longer represented in the chart, but the values remain in
the table.
To remove a data series from a chart, select the chart, and then select an element in
m
the series or click the series label in the table. Press Delete. The values are removed
from the chart but remain in the table.
To remove a data set, select the chart, and then select the category label in the table.
m
Press Delete. The values are removed from the chart but remain in the table.
If the category has no label in the table, click the data series button in the table to
convert the category to a series, select the series that contains the data you want to
remove, and press Delete.
142 Chapter 7 Creating Charts from Data