Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ela ela is offline
external usenet poster
 
Posts: 16
Default Format Data Labels

In Excel 2007 pie chart, there is an option called "format data labels" to
let you determine what types of information to show.

Unfortunately, whenever you want to change the options from default, Excel
will *automatically enable all* labels for your data.

I have 100 such data and I just wanna label some, say, the top 10 percentage
categories. Bad luck does not only have one that I have to do the same
things at least for 10 times (If my boss doesn't ask me to redo for minor
modifications).


So manually editing the charts are basically impractical, is there any
solution?


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
How select all data points/data labels at once (to format)? kippers Charts and Charting in Excel 3 April 4th 23 12:39 PM
Format Data Labels Doesn't Save GLM Charts and Charting in Excel 2 December 31st 09 06:39 PM
Format data labels for the whole chart? Ian R Charts and Charting in Excel 3 January 15th 07 10:36 PM
data labels change format john mcmichael Charts and Charting in Excel 1 March 16th 06 04:17 PM
How can I change the position/format for all data labels in a ser. PearlBeast Charts and Charting in Excel 3 December 7th 04 08:07 PM


All times are GMT +1. The time now is 03:16 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"