Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel calculate area for 3-D surface charts? | Charts and Charting in Excel | |||
Where can I find advanced info on Excel Charts? | Charts and Charting in Excel | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel | |||
Excel Charts and cells | Charts and Charting in Excel | |||
The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel |