Or, you can select the data first, then create a chart that displays the data.

Either way, when you change the data in the table, the chart updates automatically.

In Numbers, you can import a spreadsheet with charts from Microsoft Excel.

The imported charts might look somewhat different from the original, but the data they display is the same.

Tip: You can learn about different chart types in the Charting Basics template.

In Charting Basics, click the tabs near the top of the template to view the different sheets; each one explains a different type of chart.

Create a column, bar, line, area, pie, or donut chart Click in the toolbar, then click 2D, 3D, or Interactive.

If you add a donut chart and want to resize the center 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.

Click the Add Chart Data button near the selected chart (if you dont see the Add Chart Data button, make sure the chart is selected).

You can select cells from one or more tables, including tables on different sheets.

While youre editing a charts data references, appears on the tab for any sheet that contains data used in the chart.

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.

Show Chrt Title Excel For Mac