fix bubble size in bubble chart

[Micahel Chen]

The bubble size in bubble chart is adjusted automatically
by EXCEL so as to achieve best visualization result. But
when you want to see the bubble changing size, this
adjustment is bugging. For example I wrote VB code to
change the size by half every time I call it, and expected
to see the bubble size changed by half. But nothing
happened! Because EXCEL adjusted it.

How can I get out of it???

Please also reply to my email address.
(e-mail address removed) (please drop the fist 9 numbers,
it is used to dsiguise the email address from viruses.
Thanks)

 

[Andy Pope]

Hi Micahel,

One way would be to add a dummy series with a single bubble.
This would contain a constant value, probably the max of the original data.

The changes the you data would result in a reduction in bubble size.

The bubble size in bubble chart is adjusted automatically
by EXCEL so as to achieve best visualization result. But
when you want to see the bubble changing size, this
adjustment is bugging. For example I wrote VB code to
change the size by half every time I call it, and expected
to see the bubble size changed by half. But nothing
happened! Because EXCEL adjusted it.

How can I get out of it???

Please also reply to my email address.
(e-mail address removed) (please drop the fist 9 numbers,
it is used to dsiguise the email address from viruses.
Thanks)

--

Cheers
Andy

http://www.andypope.info