| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display the series name on each bubble in a bubble chart? | Charts and Charting in Excel | |||
| How do I create Multiple Series in a Bubble Chart? | Charts and Charting in Excel | |||
| Bubble chart with multiple values per series | Charts and Charting in Excel | |||
| Bubble Charting - Labels and Conditional Formatting | Charts and Charting in Excel | |||
| Bubble chart will not pick X series | Charts and Charting in Excel | |||
Hybrid Mode
