Help! Combination Column Chart

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 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/...ips/Columns.htm

and Jon Peltier has links to other sites with information:

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


Kathy wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

>-----Original Message-----
>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!
>.
>

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

Al wrote:

> 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
>
>
>>-----Original Message-----
>>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!
>>.
>>