Someone has created a bar graph that charts 4 figures per year. Therefore,
there are 4 bars for each year as displayed across the X-axis.

Is there a way to make 3 of the bars stack on top of each other while
leaving the 4th bar alone (this behavior would be repeated for each year)?
By stacking I mean after 1 bar is displayed, the next bar will begin at the
top of the previous. Thus there would be 2 bars per year but one of the bars
would be the combination of 3.

Instructions would be helpful. Outlook 2007 is what we are using. Thank you.

Hi,

There are links to examples here
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

biff wrote:
Someone has created a bar graph that charts 4 figures per year. Therefore,
there are 4 bars for each year as displayed across the X-axis.

Is there a way to make 3 of the bars stack on top of each other while
leaving the 4th bar alone (this behavior would be repeated for each year)?
By stacking I mean after 1 bar is displayed, the next bar will begin at the
top of the previous. Thus there would be 2 bars per year but one of the bars
would be the combination of 3.

Instructions would be helpful. Outlook 2007 is what we are using. Thank you.

--

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