Standardizing bubble charts?

mrhk22

New Member
Joined
Jul 10, 2016
Messages
4
I am making several bubble charts where dates are on the X-axis the Y-axis indicates the number of people who attended meetings, as does the size of the bubble.

However, the bubbles are scaled very differently across the charts even when I standardize the axis ranges (e.g. a bubble representing 15 on one chart looks about the same size as a bubble representing 25 on another). I suppose this has to do with the range of values within each chart.

Is there a way to standardize the size of the bubbles?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,119,117
Messages
5,576,196
Members
412,706
Latest member
msousa25
Top