Stack graphs and different categories

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gyzmo - 01 Apr 2008 09:48 GMT

I want to create a stacked graph showing different categories.
The Y axis is the number of respondants (preferably as a percentage)
The X axis is for things such as Age group, sex, occupation class. For each
one I want a stack with the different categories (so, age group would be for
example 10 - 20, 21-30 etc).

Can this be done at all? I'm really desparate as I need this doing today!

Thanks

Reply to this Message

Andy Pope - 01 Apr 2008 10:06 GMT

Hi,

You need to lay your data out like this,

B1:=10 -20 C1:=21-30 D1:=31-40 E1:=Male F1:=Female
G1:=AB H1:=C I1:=DE
A2:=Age B2:=3 C2:=5 D2:=2
A3:=Sex E3:=4 F3:=6
A4:=Social G4:=2 H4:=6 I4:=2

Select A1:I4 and plot a 100% stacked column plotting by Columns.

You can apply Series Data labels, although you will need to remove surplus
labels.

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I want to create a stacked graph showing different categories.
> The Y axis is the number of respondants (preferably as a percentage)
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message