Modify chart data in Pages on Mac
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 or delete a data series
Click the chart, click Edit Chart Data, then do any of the following:
Add a data series: Click a cell in a new row or column in the Chart Data editor, enter your data, then press Return or Tab. Repeat these steps until you’ve entered the entire data series.
Remove a data series: Click the coloured bar for the row or column you want to delete, click the arrow that appears, then click Delete Column or Delete Row (depending on whether you plotted rows or columns as data series).
Reorder data series: Drag the coloured bars.
Add a currency symbol or other formatting: In the Format
sidebar, click the Series tab, then use the controls to add value labels or other formatting.
Close the Chart Data editor to return to the chart.
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.
Click the chart, then click the Edit Chart Data button.
Click the row or column button in the top-right corner of the Chart Data editor.
Close the Chart Data editor when you’re done.
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 between multiple sets of y-axis values in some types of chart.
Click the chart to select it, then click the Edit Chart Data button.
Click
, then select Share X Values.Close the Chart Data editor when you’re done.
About chart downsampling
If a column, bar, line or area chart references a table with a large number of data points, the chart automatically shows a representative sample of each series to improve the performance of Pages. Downsampling doesn’t change or remove the data in your table, and only changes the visible data points in the chart.
If your chart data is being downsampled, a message appears when you click Large Data Set in the Chart tab of the Format sidebar.
If you want to see certain data points in your chart, you need to create the chart from a smaller table or a smaller selection of data from a large table.