Column, bar, line, area, pie and doughnut charts in Numbers on iPad
To create any type of graph, you can add a graph to a sheet first, then select the table cells with the data you want to use. Or, you can select the data first, then create a graph that displays the data. Either way, when you change the data in the table, the graph updates automatically.
You can import a spreadsheet with graphs from Microsoft Excel or Numbers for Mac. The imported spreadsheet might be somewhat different from the original. For example, if an imported spreadsheet has a graph with trendlines or error bars, you won’t be able to edit them or add new ones.
Tip: You can learn about different graph types in the Graph Basics template. With the spreadsheet manager in browse view, tap , then tap Charting Basics in the Basic template category. Tap the tabs near the top of the template (Column and Bar Graphs, Interactive Graph and so on) to view the different sheets — each sheet explains a different type of graph.
Create a column, bar, line or area graph, pie, or doughnut chart
Tap , then tap .
Tap 2D, 3D or Interactive to see the types of graphs you can add, then swipe left or right to see more options for each type of graph.
Note: The stacked bar, column and area graphs show two or more data series stacked together.
Tap a graph to add it to the sheet, then drag it to where you want it.
Tap the graph, then select the table cells with the data you want to use.
You can select cells in one or more tables, including tables on different sheets. While you’re editing a graph’s data references, an icon appears on the tab for any sheet that contains data used in the graph.
To change whether rows or columns are plotted as data series, tap in the toolbar, then tap an option.
Tap Done in the toolbar.
If you add a 3D graph, you see at its centre. Drag this control to adjust the graph’s orientation.
If you add a doughnut chart and want to resize the centre hole, tap , tap Graph, then drag the Inner Radius slider to make the opening larger or smaller.
You can change the data reflected in the graph at any time. To learn how, see Modify graph data in Numbers on iPad.