marklongbottom
Board Regular
- Joined
- Dec 1, 2004
- Messages
- 52
Morning all -
I have a bubble chart which looks at the proportion of the population of a school within differing levels of deprevation.
Deprivation is scored on a scale between 0 and 100, grouped into 10 groups; 0-9, 10-19, 20-29 etc - so the data looks like this.
GROUP PROPORTION
0-9 14%
10-19 12%
20-29 40% ETC
I know that a bubble chart is used to compare 3 datasets, with the size of the bubble being the "3rd axis" - but what I would like is to have the bubbles basically in a column, with the deprivation score up the right hand size, and the bubbles stacked on top of one another, rather than ranged along the horizontal axis.
Any thoughts - is this even possible?
Muchos gracias
I have a bubble chart which looks at the proportion of the population of a school within differing levels of deprevation.
Deprivation is scored on a scale between 0 and 100, grouped into 10 groups; 0-9, 10-19, 20-29 etc - so the data looks like this.
GROUP PROPORTION
0-9 14%
10-19 12%
20-29 40% ETC
I know that a bubble chart is used to compare 3 datasets, with the size of the bubble being the "3rd axis" - but what I would like is to have the bubbles basically in a column, with the deprivation score up the right hand size, and the bubbles stacked on top of one another, rather than ranged along the horizontal axis.
Any thoughts - is this even possible?
Muchos gracias