Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 4th 07, 05:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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  
Old May 4th 07, 05:42 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old May 8th 07, 09:32 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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 07:32 PM
Creating X & Y Mean Lines on Bubble Chart Chris Turnbull Charts and Charting in Excel 1 January 17th 06 08:02 PM
How do i add text labels to each bubble on bubble chart? bazza Charts and Charting in Excel 1 December 7th 05 04:02 AM
ho to change in the bubble chart the bubble position and size laszlo Charts and Charting in Excel 0 March 25th 05 04: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 07:55 PM


All times are GMT +1. The time now is 05:49 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017