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

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.


"buggy" wrote:


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

Stacked-Clustered column charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

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


buggy wrote:

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!!!!

So simple yet perfect! Thank you.


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