Chapter 10 Creating Charts from Data 227
If you switch to a bar, column, area, or line chart, each series in the new chart
corresponds to a row or column in the Chart Data Editor.
If you switch to a 3D version of a chart, the Chart inspector provides controls for
managing object depth, lighting style, and more.
Formatting you’ve applied to the chart you’re changing may not be applied to the new
chart. For example, the color ll attribute of data point elements (bars, wedges, and so
on) has a dierent default value for each type of chart. If you’ve changed a column ll
color and then change the chart to be a bar chart, the ll color change isn’t retained.
Depending on the type of chart, the attributes that may revert to the default styling
are value labels and position, text style, series stroke, series shadow, series ll, data
point symbols, and data point lls.
When you change a chart’s type and the new type has some of the same attributes,
those attributes don’t change. Shared attributes include axes, gridlines, tick marks,
axis labels, show minimum value, number format, borders, rotation, shadows, and 3D
lighting style. See “Formatting Charts” on page 228 for more information.
Bar or column charts, and stacked bar or column charts, share attributes except for
value label position. Also, bar and column charts have separate lls.
3D chart shadows are shared across chart types.
Editing Data in an Existing Chart
To edit the data in an existing chart, you must rst open the Chart Data Editor and
then enter your new data. As you edit the data, the chart is immediately updated to
reect the new data.
To open the Chart Data Editor and edit the data:
1 Select the chart.
2 Click Inspector in the toolbar, click the Chart button, and then click Edit Data.
You can also choose Format > Chart > Show Data Editor.
3 To learn about editing the data in the Chart Data Editor, including switching the data
series to use rows or columns, see steps 2 and 3 of “Adding a New Chart and Entering
Your Data” on page 225.
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 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.
Comments to this Manuals