Add a Secondary Axis to a Chart in Excel | CustomGuide

Add a Secondary Axis to a Chart in Excel

How to Create Dual-Axis Charts in Excel

Add a Secondary Axis to a Chart in Excel

Dual axis charts, also called combo charts, are great when you have two different kinds of information to present in the same chart. For example, you can have a column chart representing sales data and a line chart representing commission amounts displayed together.

Create a Dual Axis Chart

  1. Select the data you want to include in the chart.
  2. Click the Insert tab.
  3. Click the Combo button.
  4. Select Create Custom Combo Chart.
    Dual Axis Charts

    The default combo chart doesn’t include a secondary axis to label the values of the second data set. It’s best to turn this on to make the data clear for chart viewers.

  5. Click the Secondary Axis box for the data you want to display on the alternate axis.

    You can change the chart type for each series to anything you want. Use the menus in the Chart Type column to select the chart types you want to use.

  6. Click OK.
    Dual Axis Charts

Add Secondary Axis Titles

By default, the primary and secondary axis values are not labeled in the chart. Adding labels helps clarify the data being presented.

  1. Select the dual axis chart.
  2. Click the Chart Elements button.
  3. Select the Axis Titles check box.
    Dual Axis Charts
  4. Type a name in each axis text box.
  5. Dual Axis Charts

    The primary and secondary axis titles are added to the chart.