Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 192
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change font size for control labels MJP Excel Worksheet Functions 1 May 23rd 07 05:06 AM
How do I change data labels on scatterplot ahannigan Charts and Charting in Excel 8 February 2nd 07 03:55 PM
data labels change format john mcmichael Charts and Charting in Excel 1 March 16th 06 04:17 PM
VBA to change size of data labels? Jason Weiss Charts and Charting in Excel 2 March 24th 05 08:24 PM
Change the size of the data labels DrLostinExcel Charts and Charting in Excel 1 November 26th 04 07:14 PM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"