#### marklongbottom

##### Board Regular
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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

Replies
0
Views
892
Replies
0
Views
128
Replies
4
Views
112
Replies
0
Views
73
Replies
0
Views
291

1,219,812
Messages
6,150,368
Members
450,956
Latest member
Alan361

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back