ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bubble chart display (https://www.excelbanter.com/charts-charting-excel/112112-bubble-chart-display.html)

Arun

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.

Andy Pope

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


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com