Help - Complicated stacked bar chart

[Guest]

Under chart options, there's an option to do a stacked bar chart. Is there a
way to do a stacked bar chart that does the following:

I want to show 3 store locations and then have two side-by-side stacked bar
charts above each of the three location - all in one chart. The first
stacked bar would show the number of widgets bought each month of the quarter
(I need to visually represent the number bought for Jan, Feb, and March).
Then right next to it would show the number of widgets sold during the
quarter (again visually representing the number for Jan, Feb, March).
Therefore, when you see the report you'd see a side by side comparison of how
many widgets were bought and sold for each of the three locations. You'd
also be able to visually see the different amounts for each month. Is this
possible?

 

[Echo S]

http://people.stfx.ca/bliengme/ExcelTips/Columns.htm
http://support.microsoft.com/default.aspx?id=214119
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

 

[Andy Pope]

Hi,

In addition to Echo's suggestions here is an example using MS Graph.
http://www.andypope.info/ngs/ng28.htm

Cheers
Andy

 

[Echo S]

Hi,

In addition to Echo's suggestions here is an example using MS Graph.
http://www.andypope.info/ngs/ng28.htm

Ah, missed that one -- sorry!

 

[Andy Pope]

No worries, it not exactly easy to find

Cheers
Andy