[Excel] How to make a bar chart with overlapping series

These framed bar charts are useful to compare goals/targets to actual.

Overlapping bar charts in Excel
Overlapping bar charts in Excel.

Design notes

  • Use the framed series for the expected values and the filled series for the actual values.

Video

Notes