Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 22
Default adding dynamic lines or quadrants to bubble chart?

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default adding dynamic lines or quadrants to bubble chart?

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 22
Default adding dynamic lines or quadrants to bubble chart?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart with Quadrants JICDB Charts and Charting in Excel 3 March 22nd 07 08:32 PM
Creating X & Y Mean Lines on Bubble Chart Chris Turnbull Charts and Charting in Excel 1 January 17th 06 09:02 PM
How do i add text labels to each bubble on bubble chart? bazza Charts and Charting in Excel 1 December 7th 05 05:02 AM
ho to change in the bubble chart the bubble position and size laszlo Charts and Charting in Excel 0 March 25th 05 05:45 PM
How do I move a hidden bubble to the front in a bubble chart in E. Scott Excel Discussion (Misc queries) 0 February 20th 05 08:55 PM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"