how do I display two stacked columns per month on a chart
 

I need to display the contribution that 3 components make to monthly sales,
which I can do with a stacked column. How do I add in the same data from a
previous year to compare side by side?

how do I display two stacked columns per month on a chart
 

Hi,

For information on creating cluster-stacked column charts,
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ddobsy" wrote in message
...
I need to display the contribution that 3 components make to monthly sales,
which I can do with a stacked column. How do I add in the same data from a
previous year to compare side by side?