Author: Oscar Cronquist Article last updated on September 20, 2018

The Column and Line combo chart is a great choice if you want to differentiate two data series and make the chart easier to read.

How to build

  1. Select data.
  2. Go to tab "Insert" on the ribbon.
  3. Press with left mouse button on the "Insert Combo chart" button.
  4. Press with left mouse button on "Clustered Column - Line"

Add values to the x-axis

  1. Press with right mouse button on on chart
  2. Press with left mouse button on "Select Data..."
  3. Press with left mouse button on "Edit" button.
  4. Select x-axis values.
  5. Press with left mouse button on "OK" button.
  6. Press with left mouse button on "OK" button.