Parallel data series

[Guest]

How can I create a stacked staple chart where I want to compare two years
data with the same variables besides eachother per month? ie. jan06 jan07
feb06 feb07

 

[Jon Peltier]

You want a clustered-stacked column chart? Try one of these links:

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

- Jon