Updating a Chart Copied from a Numbers Document
If you’ve created a chart in Numbers, you can copy it and paste it into your Pages
document. After it’s been pasted into Pages, the chart remains linked to the data
tables it references in Numbers. To change the chart data, open the original Numbers
document and edit the data there, save the Numbers document, and then refresh the
chart data in Pages.
Â
To add rows or columns, click Add Row or Add Column to place a row above the
selected row or a column to the left of the selected column. If no row or column is
selected, the new row or column appears at the bottom or right edge of the table.
(To see the new row or column, you may have to press the Return key or the Tab
key, expand the Chart Data Editor window, or scroll.)
Alternatively, select any blank cell, type your data, and then press Return. A new row
or column is automatically created.
Â
To delete rows or columns, select the row or column label, and then press Delete.
Â
To copy data from Excel, AppleWorks, or other spreadsheet applications, copy and paste
it into the Chart Data Editor.
3
To choose whether the chart’s data series are represented by rows or columns, click
the “Row vs. Column” button in the Chart Data Editor.
This button makes the
rows of data in the Chart
Data Editor the data series.
This button makes the
columns of data in the Chart
Data Editor the data series.
To learn how to
Go to
Change a chart’s type
“Changing a Chart from One Type to Another” on
page 226
Edit a chart using the Chart Data Editor
“Editing Data in an Existing Chart” on page 227
Copy and paste a Numbers chart into a
Pages document
“Updating a Chart Copied from a Numbers
Document” on page 227
Changing a Chart from One Type to Another
You can change a chart’s type anytime you like. Some chart types, however, use the
row and column data differently, as described below.
To change a chart from one type to another:
1
Select the chart.
2
Choose a chart type from the pop-up menu in the format bar. Or click Inspector in the
toolbar, click the Chart button, and then choose a different chart type from the pop-up
menu that appears when you click the chart icon in the upper left. For a table of chart
types from which you can select, see “About Charts” on page 221.
If you switch to a pie chart, the first data point in each series is represented as a wedge.
If you switch to a scatter chart, each point in the chart requires two values. If the chart
is based on an odd number of rows or columns, the last row or column isn’t plotted.
To update a chart after you’ve updated its linked Numbers table:
Select the chart on the page and click the Refresh button that appears.
m
Note: You must save the Numbers document before copying and pasting your
chart into your Pages document and after editing the Numbers data tables that
the chart references.
To unlink the chart from its Numbers table:
Select the chart on the page and click Unlink.
m
After unlinking the chart, it behaves as any chart created in Pages, and must be
updated using the Chart Data Editor
Clicking the Source link next to the Refresh button opens the Numbers document that
the chart is linked to. (If the Source link is hidden, expand the Refresh button control
panel by dragging its handle outward.)