Using two axes in one chart

Excel 2016
Sometimes you want to show several axes in one chart to demonstrate each data series with different formatting and with different axis in one chart.
Chart with several axis in Excel 365
Chart with several axis in Excel 365

For example, if you have two too different data (e.g., sales Volume and Price), which you want to see in one chart:

Data range in Excel 365

To create one chart for these data, do the following:

   1.   Create the chart with that data range:

For example, on the Insert tab, in the Charts group, click the Insert Bar or Column Chart button:

Insert Bar or Column Chart in Excel 365

Choose Clustered Column:

Clustered Column chart in Excel 365

You can see not informative chart because of too different data scales:

Simple column chart in Excel 365

   2.   Right-click on any data series and select Change Series Chart Type... in the popup menu:

Change Series Chart Type in popup menu Excel 365

   3.   In the Change Chart Type dialog box, in the Combo group of charts, choose the secondary axis for the second data series:

Secondary Axis in Excel 365

Note: In this dialog box, you can change the chart type for each data series.

Change other parameters for the secondary axis.

To add the next data series with another axis, see Combining several charts into one chart.

See also this tip in French: Comment utiliser deux axes dans un graphique.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.