Bubble Chart Help Please

[marklongbottom]

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

 

[dave3009]

This might get you in the right direction. Unfortunately it doen't change the width of the bubble but it would give you a varying size of circle or oval.

Make a stacked bar chart

Draw a circle using autoshapes. Copy it, select the individual data range in your chart and paste your circle. You could change the colours of your circle each time you paste it into your chart.

HTH


Dave