Author: Oscar Cronquist Article last updated on February 01, 2019

Combine the stacked area chart and the clustered column chart if you want to differentiate at least two data series to 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 "Stacked area - Clustered Column" button.

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 Enter.
  6. Press with left mouse button on "OK" button.
  7. Press with left mouse button on "OK" button.