10 Replies Latest reply: Oct 7, 2015 9:00 AM by Karthik Chinnas

# Relative Bubble Size

Hi,

I'm trying to figure out how to change the relative size of the bubbles. As the values that determine the size of bubbles are relatively close, hence making the size of bubbles very similar. How can I edit the relative size of the bubbles? Changing the Max size of bubble does not help.

Thanks!

• ###### Relative Bubble Size

There is a Max Bubble Size setting on the Presentation tab of properties (Disable Autosize Symbols) that you should do what you want.

Regards,

P.Prasath

• ###### Relative Bubble Size

Hi Prasath, it didn't turn out well. I tried but all bubbles grew together and overcrowded the chart. I could hardly tell the size difference.

Wynn

• ###### Re: Relative Bubble Size

Hi,

You could probably select different styles as shown in the below screenshot. What I feel here you have selected the style for all the bubles to be in the same size and not relative.

Regards,

Subin

• ###### Relative Bubble Size

you can calculate a value for the bubble size that increases the relative difference. A simple example would be:

=sum(value) - max(TOTAL value) + .01

other formulas are possible, depending on how you want to visually represent the spread.

-Rob

• ###### Relative Bubble Size

Thanks Rob!

It works! As the values ranges from 60-90, I deduct a 50 from the value in the formula.

• ###### Re: Relative Bubble Size

Hi Rob,

Ooh I want that solution. Where do I put the formula?

Thanks!

• ###### Re: Relative Bubble Size

The bubble size is the 3rd expression in the scatter chart.

-Rob

• ###### Re: Relative Bubble Size

Found it.

I started using Google Maps within QVdocs and wanted to change the size of the bubbles on the map. Knew it should be the 3rd but it wasn't working. Turns out that I had to change the dimension...

• ###### Re: Relative Bubble Size

Hi Rob,

In the 3rd expression i am using 3 conditons to plot the bubbles in 3 different sizes i.e, HIGH, MID , LOW size.

eg: if(A='LOW',20,

if(A='MID',50,

if(A='HIGH',90)))

problem here is when all 3 values are present i.e, greater than 0. it works fine.

but when any one value is 0 then bubble size shifts by one level up.

Eg: 1. When HIGH value is 0 then MID bubble will plot in the size of HIGH and LOW bubble will plot in the size of MID.

2. if MID and HIGH both values are 0. then LOW bubble will plot in the size of HIGH.

Expection is respective bubbles should always plot in the size given in the conditon rather than automatically resize itself.

can you help on this please ?