Double 100% Stacked column charts

[buggy]

I am trying to create a monthly report that would capture the last 3
months worth of data.

The issue I am having is that I need to compare two sets of data pe
month so a clustered column chart would be ideal. Hower I need th
clustered columns to be 100% stacked columns in order to present th
appropriate data which are ratios.

For example in June we Forecasted 10% blue shoes, 50% red shoes, an
40% Green shoes (column 1 in June) however we actually got 20% blue
30% red and 50% green (column 2 in June). These two columns should b
touching whereas there should be a seperation from the other month
with similar data.

Thoughts???? HEEEELLLLLPPPPPP!!!

 

[bj]

make your stacked chart with each months data taking two rows or columns
with an empty row or cloumn between months. select one of the data series and
select options and enter "0" for the gap.

 

[Jon Peltier]

Stacked-Clustered column charts:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[buggy]

So simple yet perfect! Thank you.