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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,079
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
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,170,933
Messages
5,872,787
Members
432,947
Latest member
tchurzofretka

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