Thread: Bubble Charts in Excel

I am trying to map the position of plants using X and Y coordinates and the
area cover by each plant using the diameter in a bubble chart of Excel, but
the graphs look unrealistic. I would like to know what is the equation Excel
uses to calculate the size (area) of each point in the bubble charts so that
I can adjust my size parameter.
Thank you so much,
Juan

As I understand it, the bubble sizes are relative sizes. If you want the
data to be smaller, you'll have to put in a data point with a "large" bubble
size that you can make invisible. This will rescale the bubble sizes for
all of the other bubbles.

"Juan" <Juan@discussions.microsoft.com> wrote in message
news:4CE5DFF6-4843-4A35-9F81-4975C9BDC3ED@microsoft.com...
> I am trying to map the position of plants using X and Y coordinates and
> the
> area cover by each plant using the diameter in a bubble chart of Excel,
> but
> the graphs look unrealistic. I would like to know what is the equation
> Excel
> uses to calculate the size (area) of each point in the bubble charts so
> that
> I can adjust my size parameter.
> Thank you so much,
> Juan

Jon Peltier's article on bubble chart bubble sizes may help you:

http://peltiertech.com/Excel/Charts/...bbleSizes.html

Juan wrote:
> I am trying to map the position of plants using X and Y coordinates and the
> area cover by each plant using the diameter in a bubble chart of Excel, but
> the graphs look unrealistic. I would like to know what is the equation Excel
> uses to calculate the size (area) of each point in the bubble charts so that
> I can adjust my size parameter.
> Thank you so much,
> Juan


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you Debra for your help. However, I still have the problem. I need to
scale the size of the bubbles relative to X-Y axes for their size to show how
much space is occupied. Do you know of any available software that can do
this?
Thanks again,
Juan

"Debra Dalgleish" wrote:

> Jon Peltier's article on bubble chart bubble sizes may help you:
>
> http://peltiertech.com/Excel/Charts/...bbleSizes.html
>
> Juan wrote:
> > I am trying to map the position of plants using X and Y coordinates and the
> > area cover by each plant using the diameter in a bubble chart of Excel, but
> > the graphs look unrealistic. I would like to know what is the equation Excel
> > uses to calculate the size (area) of each point in the bubble charts so that
> > I can adjust my size parameter.
> > Thank you so much,
> > Juan
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>