how to add a secondary axis in excel for mac

When the values in a chart vary widely from data series to data series, you can plot one or more data series on a secondary axis. For example, in a column chart, you could change the data series on the secondary axis to a line chart. To help distinguish the data series that are plotted on the secondary axis, you can change their chart type. The scale of the secondary vertical axis reflects the values for the associated data series.Īfter you add a secondary vertical axis to a 2-D chart, you can also add a secondary horizontal (category) axis, which may be useful in an xy (scatter) chart or bubble chart. When the values in a 2-D chart vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. Select the drop-down arrow and choose Line.Īdd or remove a secondary axis in a chart in Office 2010 Select Secondary Axis for the data series you want to show. Select Combo > Cluster Column - Line on Secondary Axis. Your selected data set should now reside on the second axis of your chart.Note: The following procedure applies to Office 2013 and newer versions. Click on the Axis tab and select the Secondary axis radio buttonĥ. Right-click and select Format Data Series…ģ. Select a point on the graph for the data set you want to put on the secondary axis.Ģ.

If you wish to view the step-by-step, click the pic tutorial icon -> or you can follow the steps below.ġ.

The following steps were written assuming you have a chart in excel with more than one data set. Note: I used Excel 2003 for this demonstration, but it should hold true for 97-2007. If you have any comments or questions, please post them below.

Below you will find the instructions on how to add a second axis to an Excel graph. The default for all your data sets is the Primary axis, you have the option of assigning your second data set to the second axis which makes your chart readable. In order to overcome this you can assign each data set an axis. When you put these together in a chart the monthly data is diminished by the much larger YTD values. A classic example of this would be your monthly data and your YTD values for each month. When using Excel and working with two data sets that differ greatly in range it can be difficult to chart those values due to the larger range of one of your data sets.

How to add a secondary axis in excel for mac