“Creating a Chart from Table Data” on page 137
Format chart titles, legends, axes, and other
elements
“Formatting Charts” on page 143
Format pie charts, line charts, and other particular
kinds of charts
“Formatting Specific Chart Types” on page 154
Creating a Chart from Table Data
You can add a chart that shows all the data in a table or only data in selected cells of
one or more tables. If you change the data in a chart’s related table cells, the chart is
automatically updated.
When you add a chart, Numbers defines either the table rows or columns as the
default data series. In most cases, if the table is square or if it’s wider than it is tall, the
table rows become the default series, but you can easily switch the data series and sets
after the chart is created, as well as add, remove, and edit the chart data at any time.
If a table contains header rows or cells, Numbers uses text in the first column or row as
axis labels. Otherwise, placeholder text is used for labels, which you can later edit.
Here are ways to add select data and create a chart:
To add a chart based on an entire table, select the table, click Charts in the toolbar, and
m
choose a chart type from the pop-up menu.
On the pop-up menu,
2D charts are on the
left, and 3D charts are
on the right.
The values in the table are plotted in the chart. If the table is empty, the chart is blank
until you add values to table cells.
To add a chart based on a range of adjacent table cells, click in a cell, and then click
m
and drag to select other cells; you can also select the first cell in the range, and then
hold down the Shift key while selecting the last cell, to select the entire range. Then
click Charts in the toolbar, and choose a chart type.
To add a chart based on nonadjacent cells, hold down the Command key as you select
m
cells from a table. Then click Charts in the toolbar, and choose a chart type.
To add a chart based on data in more than one table, first select a single table or
m
contiguous range of cells and create a chart. Then click Charts in the toolbar, and
choose a chart type. Select the chart and hold down the Command key while clicking
or dragging cells in another table to add their data to the chart.
To add a placeholder chart to which you intend to add your data at another time,
m
make sure nothing is selected, click Charts in the toolbar, and choose a chart type.
A chart and a new table are created with placeholder data.
To draw a chart, first select the table cells you want the chart to reference, and then
m
hold down the Option key as you click Charts in the toolbar. Choose a chart type.
When the pointer changes into a crosshair, drag the crosshair across the canvas to
create a chart that’s the size you want. To constrain the chart’s proportions, hold down
the Shift key as you drag.
To learn how to
Go to
Change a chart’s type
“Changing a Chart from One Type to Another” on
page 138
Move a chart
“Moving a Chart” on page 139
Modify a chart’s data series
“Switching Table Rows and Columns for Chart
Data Series” on page 140
“Replacing or Reordering Data Series in a
Chart” on page 141
Change the data shown in a chart
“Adding More Data to an Existing Chart” on
page 140
“Removing Data from a Chart” on page 142
“Including Hidden Table Data in a Chart” on
page 141
Remove a chart
“Deleting a Chart” on page 143
Copy a chart into a Keynote or Pages document
and keep the chart up to date as data changes
“Sharing Charts with Pages and Keynote
Documents” on page 143