Charting - bubble series

[Darin Kramer]

Hi There

Im trying to chart use the bubble series, but dont understand what the
"size" component is - anyone know of some literature I can read that
will help explain this... my bubbles arnt the correct size!!

Regards

D


*** Sent via Developersdex http://www.developersdex.com ***

 

[Mike H]

I found this site useful

http://peltiertech.com/Excel/ChartsHowTo/HowToBubble.html

Mike

 

[Darin Kramer]

Thanks Mike,

The column that they entitle Bubble - which I know determines the size -
how is that calculated - ie is it a user defined relationship between
the X and Y values....?

REgars

D



*** Sent via Developersdex http://www.developersdex.com ***

 

[Tom Ogilvy]

http://office.microsoft.com/en-us/excel/HA010346071033.aspx

expand the Bubble chart entry.

 

[Jon Peltier]

There is no real relationship between bubble size and any axis scale
parameters. The default maximum bubble size is set for a chart, something
like 1/4 of the length of the shorter axis, and you can use a maximum bubble
of 0 to 300% of this default. The largest bubble corresponds to the largest
value in the bubble size range, and they decrease from there according to
the area or diameter of the bubbles (another user setting).

- Jon