how to edit all 10 bubble data labels at the same time

  • Thread starter Thread starter dstdst123
  • Start date Start date
D

dstdst123

Hi there,

Have about 10 bubbles here. 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 ?

Am using excel 2002.

Thanks.
 
This does not get you all the way there, but
Format the first then selct the second and press Ctrl+Y to repeat your
previous format, Selecet the third, Ctrl+Y and so on.
At least saves you the repeat formatting process,
 
Thanks,
Right-click a data label and select Format Data Labels...
The position will be applied to all labels.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



Hi there,
Have about 10 bubbles here. 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 ?
Am using excel 2002.
Thanks.
 
roger_home,
Bubble refers to a type of Excel chart, where instead of displaying
information using bars or lines the data is displayed as circular areas
called bubbles. Data Labels are built-in labels, that appear near or on
the bars/lines/bubbles, that describe the data.
My free Excel add-in "Chart Data Labels" allows one to customize the
label captions and to place the labels almost anywhere on a chart.
Download from...
http://www.realezsites.com/bus/primitivesoftware
Jim Cone
San Francisco, USA



in message...
what's a bubble data label?
 
Back
Top