Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 103
Default Bubble chart display

How do I get one bubble to move in front of the other? There seems to be no
relationship between the order they are listed and the order the appear on
the chart.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Bubble chart display

The order is set by the point position.

So for the following data set of X,Y,Size data you should see a set of
concentric bubbles. Where the last point with a size of 1 is on top.
Change the last points size to 5 to cover all subsequent points.
X Y Size
1 1 5
1 1 4
1 1 3
1 1 2
1 1 1

If you have more than 1 series the 2nd series is plotted over the 1st.

And finally any series on the secondary axis will be plotted above those
on the primary axis.

Cheers
Andy


Arun wrote:
How do I get one bubble to move in front of the other? There seems to be no
relationship between the order they are listed and the order the appear on
the chart.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Bubble Chart - Venn Diagram Bill Hall Charts and Charting in Excel 4 September 26th 06 06:01 PM
displaying hidden/smaller bubbles on a bubble chart kalan Charts and Charting in Excel 1 September 14th 06 11:16 AM
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
customizing the mouse-over display in a bubble chart Mark Charts and Charting in Excel 2 August 9th 05 12:01 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


All times are GMT +1. The time now is 08:49 PM.

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

About Us

"It's about Microsoft Excel"