Stack graphs and different categories

[gyzmo]

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

 

[Andy Pope]

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