Edit bubble behind another bubble in bubble chart (2007)

**JayUSA** · 07-12-2009, 01:01 PM

Hi Everyone,

Does anyone know how I can select (to edit) a bubble data point that is "behind" another larger bubble? My bubbles aren't filled; they are just circles. But I still can't seem to select a smaller bubble sitting behind / inside a larger bubble.

Cheers,

Jay

**oldchippy** · 07-12-2009, 04:19 PM

Hi,

If you click on the large bubble you should see two objects marked with four markers, then just click on the smaller one, then right click Format Data Point

**Andy Pope** · 07-13-2009, 04:57 AM

If you can not select an item directly with the mouse due to other items obscuring it then you can use the cursor keys.
http://www.andypope.info/tips/tip003.htm

Also 2007 has a drop down list of items on the Layout tab within Current Selection tab. Once the main element it selected you can use the cursor keys to move through the minor elements.

**JayUSA** · 07-14-2009, 03:10 PM

Old Chippy and Andy,

Thank you both for your posts. I was attempting Old Chippiy's technique when I accidentally stumbled upon the cursor key technique. The Layout / Current Selection technique is another real eye-opener!

Thanks again to you both,

Jay