change font of all data labels at once
 

I have excel 2003. How do you change the font/font size of all the labels at
one time? I can click on each one and do them one at a time but surely
there's a way to do them all at once? :)
Thanks

change font of all data labels at once
 

Hi,

You should be able to select all the data labels from 1 series at a time
and apply formatting.

Either you can click a label twice which in effect selects that
individual data label or you have multiple series each containing 1 data
point.

Cheers
Andy

Meenie wrote:
I have excel 2003. How do you change the font/font size of all the labels at
one time? I can click on each one and do them one at a time but surely
there's a way to do them all at once? :)
Thanks

--

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