Adding more data to an existing chart – Apple Numbers '09 User Manual

Page 140

Advertising
background image

Here are ways to move a chart:
To move a chart to a different location on the same sheet, select it and drag it to the

m

new location, or cut and paste it to the new location.
To move a chart to a different sheet, copy it, select the other sheet in the sidebar, and

m

paste it on the sheet’s canvas.

Switching Table Rows and Columns for Chart Data Series

When you select a chart, a dark frame appears around its related table cells. The data
series button in the upper-left corner of the frame around the referenced table
of a selected chart lets you transpose the table rows and columns as data series in
your chart.

These squares indicate
which color represents
each data series.

Data series button

To transpose table rows and columns as chart series:
Select the chart, and then click the data series button.

m

When the button looks like this, the columns are data series.
Click the button to make rows the data series.

When the button looks like this, the rows are data series.
Click the button to make columns the data series.

Adding More Data to an Existing Chart

You can add data from individual cells that are adjacent or nonadjacent to those
already referred to by your chart, include an entire new row or column, or add data
from multiple tables.

Here are ways to add more data to a chart:
To add data from cells that are adjacent to cells already plotted, select the chart and

m

then hold down the Shift key as you click the cells you want.

140

Chapter 7

Creating Charts from Data

Advertising