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. Click the "Insert Combo chart" button.
  4. Click "Clustered Column - Line"

Add values to the x-axis

  1. Right-click on chart
  2. Click "Select Data..."
  3. Click "Edit" button.
  4. Select x-axis values.
  5. Click "OK" button.
  6. Click "OK" button.