Stack Column Chart

[Guest]

In PPT 2002 can you have more than 1 stack column bar in the same category,
say product A with 2 data values, and product B with 2 data values in Qtr. 1,
and the same for Qtr 2. I believe it cannot be done on the datasheet
automatically but was just checking. Suggestions on what other charting
software that can perform something like this would be appreciated.

regards,
Fritz78

 

[Andy Pope]

Hi,

Here is an explanation of the work around.
http://www.andypope.info/ngs/ng28.htm

Cheers
Andy

 

[Guest]

Thank You! Andy,

This definitely helps. Of course I added another twist, I added a line
chart to make it a combo chart, the hard part was to get the Qtr. labels to
appear, I used text boxes. Your first chart example worked the best. Now
I'm wondering if we can get excel data to link, to update faster?

Fritz78