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. Press with left mouse button on "Insert Combo Chart" button.
  4. Press with left mouse button on "Clustered Column - Line on secondary axis" button.
  5. The chart appears.
  6. The x-axis values are missing, press with right mouse button on on chart.
  7. Press with mouse on "Select Data..." to open the "Select Data Source" dialog box.
  8. Press with left mouse button on "Edit" button.
  9. Select x-axis values and then press Enter.
  10. Press with left mouse button on OK button.
  11. Press with left mouse button on OK button.