Two Data Sets: Stacked Column Chart

[Rainmaker]

How do I show two years side-by-side in a stacked column chart? I want to
compare two "stacked" columns each month (one for each year). I can create
one showing each month for ONE year but I want to add another year in another
stacked column for each month. Can this be done?

 

[Luke M]

Yes, it can be done. It just takes some careful arrangement of data. See Jon
Peltier's excellent site on charting:

http://peltiertech.com/WordPress/clustered-stacked-column-charts/

(depending on your browser, you may need to scroll down a bit to get to
beginning of article)