Charting - bubble series
 

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 ***

Charting - bubble series
 

I found this site useful

http://peltiertech.com/Excel/ChartsH...wToBubble.html

Mike

"Darin Kramer" wrote:


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 ***

Charting - bubble series
 

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 ***

Charting - bubble series
 

http://office.microsoft.com/en-us/ex...346071033.aspx

expand the Bubble chart entry.

--
Regards,
Tom Ogilvy


"Darin Kramer" wrote:


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 ***

Charting - bubble series
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Darin Kramer" wrote in message
...
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 ***