How to Make a Secondary Axis Graph in Numbers

By Richard Gaughan

The Numbers program in Apple's iWork office software suite gives you the option to plot your data in any one of more than a dozen basic chart formats. Options within those chart types give you even more possibilities. One option is the 2-axis chart, which lets you visualize variations in different parameters for the same items, such as students' performance on homework and on tests. The process is straightforward: select the 2-axis chart type, and then modify the format options until you get just what you're looking for.

Step 1

Enter the label for your data in one column of the spreadsheet, and then enter the two series of related data in adjacent columns of the spreadsheet. For example, the first column could be students' names, and the next two columns could be their grades on math homework and math tests.

Step 2

Highlight the label column and the two columns of data, select "Insert," hover over "Chart>," and then click "2-axis." The chart appears with both the primary and secondary axis values. The first data series defaults to a line plot and the second data series defaults to a column plot; the two are different colors.

Step 3

Click on the chart, open the inspector window, and then click the "Chart" button to adjust display options for the title and legend options.

Step 4

Click the "Axis" button -- with the chart still selected and the inspector window open -- to choose such characteristics as whether or not to show the axes, the number of values to be shown, and the location and spacing of tick marks.

Select the chart if it's not still selected, and then re-open the inspector window, if necessary. Click on one of the data displays on the chart to select one of the data series, then select the "Series" button to modify the labels and the data series type, and to swap the primary and secondary axes.

×