Thread: Double 100% Stacked column charts

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

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.