Help! Combination Column Chart

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I have three data series: A, B and C. B is a subset of A. I want to
stack An and B have a separate column for C. I don't need, and prefer
not to have, a separate Y axis for C. Have tried everything and can't
figure it out Thanks Group!
 
If the only reason for not using a secondary Y axis is
that you don't want it to be visible, do you know that you
can but make it not visible? (Format the axis: using the
Patterns tab, select none, none, none, none.)

Al
 
In fact, you can tell Excel to plot a series on the secondary axis, then use Chart
Options to clear the secondary axis. The chart still knows the series in in the
secondary axis group, so it will not be plotted as a member of the first axis group.
This means you don't have to keep unhiding the secondary axis to make its scale
match the primary scale.

This isn't how I'd do the stacked clustered column chart, though.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top