Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stack graphs and different categories
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stack graphs and different categories
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "gyzmo" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
let me make multiple bar stack graphs in excel | Charts and Charting in Excel | |||
Stack Charts? ? ? Please help | Excel Discussion (Misc queries) | |||
Stack Charts? ? ? Please help | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
How can I stack 3-D columns | Charts and Charting in Excel |