software

Hi ...

Have about 10 bubbles there. Need to format data labels of ALL 10
bubbles at the same time. (I wanna select Alignment gt; label position gt;
center, that means moving all 10 data labels to the center of the
bubbles)

Any method that i can do it in one go, without the need to select and
format it one by one ?

Using Excel 2002.

Thanks.Hi,

If the bubbles are all different series then no. You can reduce the time
by using F4 which will repeat the command. So format one data label and
then select another and press F4.

Cheers
Andy
wrote:
gt; Hi ...
gt;
gt; Have about 10 bubbles there. Need to format data labels of ALL 10
gt; bubbles at the same time. (I wanna select Alignment gt; label position gt;
gt; center, that means moving all 10 data labels to the center of the
gt; bubbles)
gt;
gt; Any method that i can do it in one go, without the need to select and
gt; format it one by one ?
gt;
gt; Using Excel 2002.
gt;
gt; Thanks.
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info