bubble chart - how to edit all in one go

[dstdst123]

Hi ...

Have about 10 bubbles there. Need to format data labels of ALL 10
bubbles at the same time. (I wanna select Alignment > label position >
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.

 

[Andy Pope]

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