To learn how, see Modify chart data in Numbers on Mac. You can change the data reflected in the chart at any time. To change whether rows or columns are plotted as a data series, choose an option from the pop-up menu in the bar at the bottom of the window.Ĭlick Done in the bar at the bottom of the window. While you’re editing a chart’s data references, a dot appears on the tab for any sheet that contains data used in the chart. You can select cells from one or more tables, including tables on different sheets. Select the table cells with the data you want to use.
If you add a doughnut chart and want to resize the centre hole, click the Segments tab in the Format sidebar, then in the Inner Radius section of the sidebar, drag the slider or type a specific value.Ĭlick the Add Chart Data button near the selected chart (if you can’t see the Add Chart Data button, make sure the chart is selected). Kasper Langmann, Co-founder of Spreadsheeto To freeze both the first three columns (as in the previous example) as well as the first row (our header row), we select cell D2. Drag this control to adjust the chart’s orientation. Recall that for multiple rows we chose a cell in the first column and for multiple columns, we chose a cell in the first row.
If you add a 3D chart, you see at its centre. Note: The stacked bar, column and area charts show two or more data series stacked together.