Creating a stacked bar chart and overlapping all data series

[DashboardNovice]

http://chandoo.org/wp/2008/10/29/box-plots-excel-dashboards-tutorial/

Step 3 says to create a stacked bar chart, but it doesn't say how to get all 4 data series to overlap. I did change the 'Overlap' and 'Gap' settings to what the finished workbook has.

How do I get all 4 data series to overlap?

 

[vijay.vizzu]

Please upload a sample file...

 

[DashboardNovice]

Please upload a sample file...

As it turns out, I managed to figure this out. Apparently, you have to copy then paste each data series individually, instead of selecting all of them at once. By selecting each individually, this allows you to add one category at a time. Then you can overlap them.