Note: When you copy and paste a chart into Keynote or Pages you are creating a link. If you then change the chart in Numbers, after saving, click the copy in Keynote or Pages and controls will appear. Click the refresh button to update. You can also click to Unlink and stop the ability to update in this way.

Create a Chart

1. Go to Insert - Chart or use the Charts button on the Toolbar. (The chart you added already has data? Change it. Don’t be shy.)
2. The Chart Inspector opens up. Use it or close it.
(You can click on various objects in your chart and change them.)
3. Rename the chart in the Sheets Pane.
– or –
1. Select your cells or table.
2. Click the Charts button on the Toolbar
3. The Chart Inspector opens up. Use it or close it.
(You can click on various objects in your chart and change them.)
4. Rename the chart in the Sheets Pane.

Create a Mixed Chart

1. Go to Insert - Chart - Mixed or use the Charts button on the Toolbar and choose one of the last two chart icons on the left.
(The chart you added already has data? Change it. Don’t be shy.)
– or –
1. Select your cells or table.
2. Click the Charts button and choose one of the last two chart icons on the left.
3. Either way, the Chart Inspector opens up. Use it or close it. (You can click on various objects in your chart and change them.)
4. Rename the chart in the Sheets Pane.

Create a Mixed Chart from Multiple Tables

1. Select your cells.
2. Click the Charts button on the Toolbar.
3. Select the chart.
4. Command-Select your next set of cells on another table to add another set of data to the selected chart.

Create a 2-Axis Chart

1. Select your table.
2. Click the Charts button and choose the last chart icon on the left.
3. Select the chart.
4. Two selection methods:
on the chart, select the chart element that you want to make relevant to a y-axis
– or –
on the table, click the color square next to the information that you want to make relevant to a y-axis.
5. Then go to Chart Inspector - Series - Plot on.

Can’t see the legend? Something not right?

When in doubt – click the Inspector button in the Toolbar and explore the Chart Inspector.

Change Chart Type

1. Select chart on sheet.
2. Control-Click - Chart Type - Pick a new choice

Any questions?

return to top