Modify chart data references

You can modify a chart’s data (numbers, dates, or durations) at any time. You can add and remove entire data series, or edit a data series by adding or deleting specific data from it.

Add, edit, or delete a data series

  1. Tap a chart, then tap Edit Data.

  2. Do any of the following:

    • Add a data series: Tap cells, then enter the data comprising your new data series.

    • Remove a data series: Tap the colored bar for the row or column you want to delete, then tap Delete.

    • Reorder data series: Drag a colored bar for a row or column to reorder the data series.

    • Enter dates, times, and durations: Tap Configure button, turn on Full Keyboard, then enter your data.

  3. Tap Done.

Switch rows and columns as data series

When you add a chart, Pages defines default data series for it. In most cases, if a table is square or if it’s wider than it is tall, the table rows are the default series. Otherwise, the columns are the default series. You can change whether rows or columns are the data series.

  1. Tap a chart, then tap Edit Data.

  2. Tap Configure button, then tap Plot Rows as Series or Plot Columns as Series.

  3. Tap Done to return to the chart.

Share the x-axis for multiple values along the y-axis for scatter and bubble charts

Sharing the x-axis means plotting a single kind of value along the x-axis, while allowing for multiple kinds of values plotted along the y-axis. By default, the x-axis values are shared among multiple sets of y-axis values in some types of charts.

  1. Tap the chart, then tap Edit Data.

  2. Tap Configure button, then tap Share X Values.

  3. Tap Done.

If you can’t edit a chart, you may need to unlock it.

See also
Adjust chart markings and labels
Change the look of a chart