Apple Numbers '09 - Manual (Page 141)

Chapter 7 Creating Charts from Data 141
To add data from cells that aren’t adjacent to cells already plotted, select the chart and m
then hold down the Command key as you click or drag the cells you want.
To extend the range of adjacent cells whose values are plotted, select the chart. In the
m
table, drag the circular control in the lower right of the range to the right or down.
If the chart is a scatter chart, dragging lets you add only an even number of rows
or columns.
To add a new row or column of data, select the table and insert the row or column
m
between cells that are already plotted. When you add data to the new cells, the data
will be plotted in the chart.
To add data from cells in a different table, select the cells with data you want to add,
m
and then drag them to the chart.
The new data is added as a new data series. To view or change the chart’s source data,
click a data series in the chart to see its table and cells of origin.
To include data from hidden rows and columns in your chart, see “Including Hidden
Table Data in a Chart” on page 141.
Including Hidden Table Data in a Chart
If you’ve hidden rows or columns in a table, but want to include or exclude them from
a chart, you can elect to do so in the Chart pane of the Chart inspector.
To include or exclude hidden data:
1 Select the chart, and then click the Inspector button in the toolbar.
2 Click the Chart button in the Inspector window, click Chart, and then do one of
the following:
To include hidden data in your chart, select Show Hidden Data. Â
To exclude hidden data from your chart, deselect Show Hidden Data. Â
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.