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

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

For example in June we Forecasted 10% blue shoes, 50% red shoes, and
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 be
touching whereas there should be a seperation from the other months
with similar data.

Thoughts???? HEEEELLLLLPPPPPP!!!!


--
buggy
------------------------------------------------------------------------
buggy's Profile: http://www.excelforum.com/member.php...o&userid=16666
View this thread: http://www.excelforum.com/showthread...hreadid=385336