Forum Discussion
T3chNick
Advocate I
Advocate IWrong bubble size in Scatter chart
Hello I don't know how the size of each bubble is calculated, but there seems to be an automatic 'rescaling' which doesn't seem right to me. The area of the bubble is obviously not directly propo...
Hi,
It could be due to negative numbers present in column which is used for bubble size. Try converting negative numbers to zero in formula , IF(column_value<0,0,column_value).
T3chNickAdvocate I
Advocate IHi karthick,
Thanks for your input. But this is not due to negative numbers, I've given an example in my first post.
Here's the table you could manually input for testing purposes :
| Letter | Size | Order |
| A | 1 | 1 |
| B | 10 | 2 |
| C | 1000 | 3 |
| D | 1000000 | 4 |
| E | 10000000000 | 5 |
Then add 'Letter' as a legend, 'Order' as Y axis and 'Size' as size. Add a slicer on the letters and play with it. If you display them all, only E will be bigger, and then A=B=C=D (visually in size) and that is just wrong.