Increase Bubble Chart Size

Buttercup
Buttercup Member
in Charting

I'm using bubble chart now, to show Sales by Region.

Some value of sales are in Billion unit while other also in Million.

image.png

It really doesn't make sense when user choose Year A it show perfect bubble,

then Year B size very small.

image.png

How to adjust the size? Already consider to rescale the data but then it'll affect the data accuracy. Hence i don't use this option. Please advise me.

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    Can you transform your data in an ETL? Apply a formula like Log(Value) or Value / Scaling Factor to adjust the bubble sizes.

    Create a calculated field to adjust the size values directly. A formula to scale down or normalize your values. For example, Size = [Original Size] / 1,000,000 to convert billions to millions.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    Can you transform your data in an ETL? Apply a formula like Log(Value) or Value / Scaling Factor to adjust the bubble sizes.

    Create a calculated field to adjust the size values directly. A formula to scale down or normalize your values. For example, Size = [Original Size] / 1,000,000 to convert billions to millions.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories