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 dierently, 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 dierent 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 rst 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.
226 Chapter 10 Creating Charts from Data
Comments to this Manuals