Apple numbers User Manual

 Using Charts

 

You can change the row or column on which a data series is based to a different row or 
column.

Select the chart.

Select the series you want to move, either by clicking the data series in the chart or by 
clicking the data series label in the table.

Drag the data series in the table to the row or column you want to use as a 
replacement.

You can delete a chart by deleting its related table(s), or you can delete only the chart.

m

To remove the chart and not its related table(s), select it and press Delete.

m

To remove both the chart and its related table(s), select the table(s) and press Delete.

You can move a chart within a spreadsheet by dragging it or by cutting and pasting it. 
Its connections to related cells are maintained.

m

To move a chart to a different location on the same sheet, select it and drag it to the 
new location.

m

To move a chart to a different sheet, in the sidebar select the chart and drag it to the 
new sheet.

You can also select the chart and cut it (Command-X), select the other sheet, and then 
paste it (Command-V). Drag the chart to refine its location on the sheet.

You can change a chart’s type anytime you like.

Select the chart.

Click Inspector in the toolbar, click the Chart Inspector 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.

If you switch to a pie chart, the first data point in each series is represented as a wedge. 
See “Pie Charts” on page 113.