Numbers User Guide for Mac
- Welcome
-
- Intro to Numbers
- Intro to images, charts, and other objects
- Create a spreadsheet
- Open or close spreadsheets
- Personalize templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Touch Bar for Numbers
- Use VoiceOver to create a spreadsheet
-
- Use iCloud with Numbers
- Import an Excel or text file
- Export to Excel or another file format
- Reduce the spreadsheet file size
- Save a large spreadsheet as a package file
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Lock a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates
- Copyright
Select data to make a chart in Numbers on Mac
In Numbers, charts are created using data from a table. To create any type of chart, you can select the data first, then create a chart that displays the data. When you change the data in the table, the chart updates automatically.
Select the data before creating your chart
Select the table cells with the data you want to use, or to add data from an entire row or column, click the table, then click the number or letter for that row or column.
You can select cells from one or more tables, including tables on different sheets. When you edit a chart’s data references, a dot appears on the tab for any sheet that contains data used in the chart.
If the data in your table is categorized, you can also select a column to plot the results of a summary row calculation.
Note: To chart individual data points in a categorized table, make sure the first cell you select is not in a summary row. If the selection includes a group that’s collapsed, only data from the visible groups is plotted.
Click , then click 2D, 3D, or Interactive.
Click the left and right arrows to see more style options.
Click a chart or drag it to the sheet.
If you add a 3D chart, you see at its center. Drag this control to adjust the chart’s orientation.
To change whether rows or columns are plotted as a data series, click Edit Data References, then click the pop-up menu in the bar at the bottom of the window and choose an option.
Click Done in the bar at the bottom of the window.
You can adjust the data reflected in the chart at any time. To learn how, see Modify chart data in Numbers on Mac.