Help! Combination Column Chart

[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!

 

[Debra Dalgleish]

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 Jon Peltier has links to other sites with information:

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

 

[Al]

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

 

[Jon Peltier]

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/
_______