|
Stacked column chart
m... bit hard to explain. Basically I'm doing an analysis of the words used to refer to female body parts in an issue of Nuts magazine.
I want to make a bar chart that shows the number of references to each body part (e.g. breasts, bottom).
i.e. on the x-axis i want labels for breasts, bottom, body, legs, face.
But I wanted to make each column stacked so that the frequency of each different term used (e.g. breast column to show number of times boobs, **** etc used. Bottom column to show number of times bum, **** used etc)
I understand the basics of stacked column charting, but I don't know how to create stacks, when the sections in each stacked column are unrelated to each other.
That probably doesn't make much sense....
If this is really complicated, just say, cos I am an excel virgin! and I'm sure to get completely stuck with a load of computor gobbledegook instructions!!
Thanks for taking the time to read this!
Katie, a tired student who's been working all night to try and get an assignment done for Thursday!!
|