Adding data to a chart from multiple tables, Removing data from a chart – Apple Numbers '08 User Manual
Page 104
104
Chapter 6
Using Charts
m
To add cells based on a new row or column, select the table and insert the row or
column between cells that are already plotted. When you add data to the new cells, the
data will be plotted in the chart.
Adding Data to a Chart from Multiple Tables
You can add data to a chart from cells that are in more than one table.
To chart data in multiple tables:
1
Create a chart based on data from one table.
2
Select cells in another table.
3
Drag the selected cells into the chart. They’re 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.
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 from a chart:
m
To remove a data point, select the table, select the cell in which the data resides, and
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.
m
To remove multiple individual cell values, select the table, use Shift-click or Command
click to select the cells, and then press Delete. The values are removed from both the
table and the chart.
m
To shrink the range of adjacent cells whose values are plotted, select the chart. In the
table, 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.
m
To remove a data series, click the chart, select an element in the series or click the
series label in the table, and then press Delete. The values are removed from the chart
but remain in the table.
m
To remove a data set, click the chart, select the category label in the table, and 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.