Stack Column Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fritz78 - 24 Oct 2006 19:52 GMT

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

Reply to this Message

Andy Pope - 24 Oct 2006 20:02 GMT

Hi,

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

Cheers
Andy

> 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,
[quoted text clipped - 4 lines]
> regards,
> Fritz78

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

fritz78 - 26 Oct 2006 17:32 GMT

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

> Hi,
>
[quoted text clipped - 12 lines]
> > regards,
> > Fritz78

Reply to this Message