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

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

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

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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 ***