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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,118,415
Messages
5,571,977
Members
412,430
Latest member
Huuktkt
Top