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