Author: Oscar Cronquist Article last updated on October 15, 2018

The combination chart category lets you build a chart that has columns on the primary axis and the line on a secondary axis which is great if the ranges are vastly different.

How to build

  1. Select cell range.
  2. Go to tab "Insert" on the ribbon.
  3. Click "Insert Combo Chart" button.
  4. Click "Clustered Column - Line on secondary axis" button.
  5. The chart appears.
  6. The x-axis values are missing, right click on chart.
  7. Click on "Select Data..." to open the "Select Data Source" dialog box.
  8. Click "Edit" button.
  9. Select x-axis values and then press Enter.
  10. Click OK button.
  11. Click OK button.