Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Scatter plot dot size issue

I am working on a small dataset (98) on cars, and would like to do the size map to value of weight. But when I drag the weight to the size, the bubble is very large although I have already set the si...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

For your scenario, I'm afraid that you may could adjust the start and end parameters of the X-Axis and Y-Axis to avoid the bubble overlap from each other.

 

 

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you for your suggestion. I tried but the result is not satisfied. The bubble is still overlapping, if I start from 0-5000, it will be narrow. if i start 1500-5000, some data will missing. but the bubble's size didn't change. Thank you anyway.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    If it is convenient, could you share your sample data which could reproduce your scenario so that I could copy and have a test.

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Sure. Absolutely. I would like to set Weight as x axis, MPG as y axis, color mapping to Manufacturer, size mapping to Weight. And scales not from 0. Below is my sample dataset. Thank you for your help!

      ManufacturerMPGWeight
      ford173449
      ford154341
      ford 4034
      ford 3353
      toyota242372
      ford212587
      bmw262234
      ford104615
      toyota252228
      ford252046
      ford193302
      ford144154
      ford134746
      ford183139
      toyota311773
      toyota242278
      ford212226
      ford144129
      ford134294
      ford222395
      toyota232506
      toyota272100
      ford144042
      ford134363
      ford183021
      ford124906
      toyota202279
      ford192310
      toyota202807
      ford212875
      ford262451
      toyota321836
      ford164141
      ford144638
      toyota311649
      honda242489
      ford153158
      ford144657
      ford133169
      toyota292171
      ford232639
      toyota242702
      ford182984
      honda331795
      ford14.54215
      ford243012
      honda331795
      ford183574
      toyota282155
      ford26.52565
      toyota192930
      mercedes16.53820
      ford133870
      honda31.52045
      ford18.53525
      ford164335
      toyota262265
      ford25.52755
      bmw21.52600
      ford36.11800
      honda36.11800
      ford20.22965
      ford25.12720
      ford18.13205
      toyota27.52560
      toyota21.12515
      honda29.52135
      ford22.32890
      ford17.63725
      ford15.54054
      mercedes25.43530
      toyota38.11968
      ford26.42870
      toyota29.82711
      toyota32.22265
      mercedes303250
      honda44.61850
      ford23.62905
      honda32.42290
      toyota39.11755
      honda35.11760
      toyota37.72050
      ford34.42045
      ford29.92380
      honda33.72210
      toyota32.42350
      toyota25.42900
      ford20.23060
      ford242865
      honda362205
      toyota342245
      honda381965
      honda321965
      ford222835
      toyota322665
      ford272790
      ford282625
      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous，

         

        From your first post, it seems that you would like to do the size map to value of weight, but when you drag the weight to the size, the bubble is very large.

         

        By my test, you could set the size like below so that the bubble will be smaller.

         

         

        More details, you could refer to my attachment.

         

        Hope this can help you!

         

        Best Regards,

        Cherry