Modify graph data in Numbers on iPhone
You can modify a graph’s data references (numbers, dates or durations) at any time. You can add and remove an entire data series or edit a data series, by adding or deleting specific data from it.
While you’re editing a graph’s data references, a small white triangle appears on the tab of each sheet that contains data used in that graph.
If you can’t edit a graph, it may be locked. Unlock it to make changes.
Add or delete a data series
Tap a graph, then tap Edit References (you may need to tap
to see it).Do any of the following:
Remove a data series: Tap the coloured dot for the row or column you want to delete, then tap Delete Series.
Add an entire row or column as a data series: Tap the header cell for the row or column. If there is no header cell, drag to select the cells in the row or column.
Add data from a range of cells: Touch and hold, then drag across the table cells.
Add or remove data from an existing data series: Tap the coloured dot for the row or column, then drag the blue dot at the corner of the selection box to include the cells you want.
When you’re finished, tap Done.
Resize individual data series
Tap a graph, then tap Edit References (you may need to tap
to see it).Tap
in the toolbar, then turn on Show Each Series.Tap Done.
Drag the blue dots to include only the cells you want in each series.
Tap Done to return to the graph.
Switch rows and columns as data series
When you add a graph, Numbers defines the 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.
If your table contains categories and choose a column as the data series, you can also choose whether you want the graph to include summary or body cells.
Tap a graph, then tap Edit References (you may need to tap
to see it).Tap
, then tap Plot Rows as Series or Plot Columns as Series.Tap Done, then tap Done again to return to your spreadsheet.
Include hidden data in a graph
When you import a spreadsheet that includes hidden data (data in hidden rows or columns, or data hidden due to data filtering), you can choose to include that hidden data in your graphs. By default, hidden data isn’t included.
Tap a graph, tap
, then tap Data.Turn on Show Hidden Data.
For more information about how to hide table rows or columns, see Add or remove rows and columns in Numbers on iPhone.
About graph downsampling
If a column, bar, line or area graph references a table with a large number of data points, the graph automatically shows a representative sample of each series to improve the performance of Numbers. Downsampling doesn’t change or remove the data in your table, and only changes the visible data points in the graph.
If your Graph data is being downsampled, a message appears when you tap Large Data Set in the Graph tab of the Format menu.
If you want to see certain data points in your graph, you need to create the graph from a smaller table or a smaller selection of data from a large table.