stacked bar, and column, two axes

[Guest]

with a stacked bar, and a column, on two separate axes, the current chart has
the column that's on the second axis right over top of the stacked bar.

Is there a way to move the column so that it is beside the stacked bar, not
on top of it?

The manage would also like to add a line, in addition to the stacked bar and
the column. ??

 

[Guest]

sort of gettin' it.

thanks.

http://support.microsoft.com/default.aspx?scid=kb;en-ca;214119

 

[Jon Peltier]

Do you mean a stacked column on the primary axis, and a single column on the
secondary axis? Because stacked bars run horizontally and stacked columns
vertically.

If you're after a mixed stacked-clustered chart, try one of these links:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Then to add a line you have several options:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon