change font of all data labels at once

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Meenie - 09 May 2008 19:04 GMT

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

Reply to this Message

Andy Pope - 09 May 2008 22:02 GMT

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

> 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

Signature

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

Reply to this Message