Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
hello!
I have a bubble chart which I'm trying to add lines (or coloured squares) to, so I can group the bubbles into 4 defined-by-cell-value parts of the chart Currently I have 2 lines crossing the chart which I have to manually move if values change (they should each cross the axis at the weighted average point) but as the chart is going to be made into multiple versions I want to automate as much as possible I did see Mr Peltier's guide for adding dynamic quadrants to x-y charts (I don't mind if the bubbles are segmented by rectangles either!) but couldn't find anything showing me how to do it with bubbles - any ideas? using XL 2003 Many thanks in advance for any assistance! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Unfortunately bubble charts cannot be combined with other chart types. You
can use custom-sized markers (e.g., large and small circles) for the points of an XY chart with area or column chart backgrounds: http://peltiertech.com/Excel/ChartsH...omMarkers.html But this is not natively dynamic. You would have to use VBA and some kind of event procedures to make the bubbles update when the data changed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "griff" wrote in message ... hello! I have a bubble chart which I'm trying to add lines (or coloured squares) to, so I can group the bubbles into 4 defined-by-cell-value parts of the chart Currently I have 2 lines crossing the chart which I have to manually move if values change (they should each cross the axis at the weighted average point) but as the chart is going to be made into multiple versions I want to automate as much as possible I did see Mr Peltier's guide for adding dynamic quadrants to x-y charts (I don't mind if the bubbles are segmented by rectangles either!) but couldn't find anything showing me how to do it with bubbles - any ideas? using XL 2003 Many thanks in advance for any assistance! |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Thanks Jon for the reply - I may not be able to build the chart as I was
asked to, but at least now you've told me it can't be done I need not waste any more time searching for the magic solution in Excel! cheers griff "Jon Peltier" wrote: Unfortunately bubble charts cannot be combined with other chart types. You can use custom-sized markers (e.g., large and small circles) for the points of an XY chart with area or column chart backgrounds: http://peltiertech.com/Excel/ChartsH...omMarkers.html But this is not natively dynamic. You would have to use VBA and some kind of event procedures to make the bubbles update when the data changed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "griff" wrote in message ... hello! I have a bubble chart which I'm trying to add lines (or coloured squares) to, so I can group the bubbles into 4 defined-by-cell-value parts of the chart Currently I have 2 lines crossing the chart which I have to manually move if values change (they should each cross the axis at the weighted average point) but as the chart is going to be made into multiple versions I want to automate as much as possible I did see Mr Peltier's guide for adding dynamic quadrants to x-y charts (I don't mind if the bubbles are segmented by rectangles either!) but couldn't find anything showing me how to do it with bubbles - any ideas? using XL 2003 Many thanks in advance for any assistance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart with Quadrants | Charts and Charting in Excel | |||
Creating X & Y Mean Lines on Bubble Chart | Charts and Charting in Excel | |||
How do i add text labels to each bubble on bubble chart? | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) |