Bubble Chart Help Please

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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,006
Office Version
  1. 365
  2. 2016
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
 

Forum statistics

Threads
1,136,993
Messages
5,679,023
Members
419,800
Latest member
spvsr999

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top