Two stacked bars per series

[Rita Palazzi]

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

 

[Andy Pope]

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