fix bubble size in bubble chart

  • Thread starter Thread starter Micahel Chen
  • Start date Start date
M

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)
 
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.

Micahel said:
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)
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top