Two stacked bars per series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rita Palazzi - 29 Apr 2004 18:03 GMT

Office 2000
Windows XP

I have a stacked bar graph showing actual values per country per month. I
have been asked to add a second stacked bar showing the projected country
value by month. So basically, each month needs to have two stacked bars
associated with it. Is this possible and if so, how?

Thanks in advance for any help!

Rita Palazzi
Senior Engineer / FedEx Express

Reply to this Message

Andy Pope - 29 Apr 2004 21:55 GMT

Hi Rita,

If you stagger your data, you can create side-by-side stacked columns.

Bernard Liengme has an example and instructions on his site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

and the following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?id=214119

Cheers
Andy

> Office 2000
> Windows XP
[quoted text clipped - 8 lines]
> Rita Palazzi
> Senior Engineer / FedEx Express

Signature

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

Reply to this Message