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

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. Press Enter.
  6. Click "OK" button.
  7. Click "OK" button.