Hi Monica,

Attached you will find an example. If these don't work let me know more
about your chart. If this works for you I will explain it. There is
another solution, but lets see if this works.

Cheers,
Shane

"Monica Horvath" wrote in message ...
I am starting with a (2D) bar graph with three series. I want a stacked
bar graph for two of the series, but the the third series plotted as its
own bar on the same axes.

In excel 2007 I right click to change series chart type on the two series
I want to stack, and doing this stacks all three of them. No order
combination of right-click-changing seems to make a difference. I have
even tried to make a 'ghost' 2nd y-axis for the 2 series I want to stack,
but XL stacks all three regardsless. Any way around this? If I plot the
third 'lone' series as a line, it works fine; i.e. the other two remain
the stacked bar.

Very vexing!

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com