• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Bubble chart radius vs area

S

Smyers

New Member
The chart takes the desired bubble radius as an input. However, I want to specify the area because that is my data, and inputting the area as the radius gives me the wrong size bubbles, however my labels are correct. Converting from area to radius is easy, so then I get the correct (relative) sized bubbles. However, my bubble labels are then the radius and not the area, so I face a trade-off. Is there a way around this?
Thank you
 
Hi Myers ,

I am not able to understand your problem ; can you not select each individual data label , and in the formula bar select the cell whose value should appear in that data label ? This will insert a formula for that data label. Repeat this with the other data labels , selecting them individually.

Narayan
 
Yes but the problem is that I have many such charts, and the number of entries changes, was hoping there was a more automated workaround?
 
You must log in or register to reply here.
Back
Top