|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 24th, 2010, 03:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
