ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do i "bring to front" bubbles in excel bubble charts which ar. (https://www.excelbanter.com/charts-charting-excel/17003-how-do-i-%22bring-front%22-bubbles-excel-bubble-charts-ar.html)

Ganesh

How do i "bring to front" bubbles in excel bubble charts which ar.
 
How do i "bring to front" bubbles in excel bubble charts which are hidden by
a bigger bubble in the same data area ? Is there a way to bring the smaller
bubble to appear above (in front of )the bigger bubbles ?

Andy Pope

Hi,

If all the bubbles are in one series you could sort the x and y data on
bubble size descending.

If each bubble is a data series then you could change the series order.

Cheers
Andy

Ganesh wrote:
How do i "bring to front" bubbles in excel bubble charts which are hidden by
a bigger bubble in the same data area ? Is there a way to bring the smaller
bubble to appear above (in front of )the bigger bubbles ?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 02:28 PM.

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