From: ela on 24 Apr 2010 10:20 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?
|
Pages: 1 Prev: Reference: forum discussion dated 17-18April2010 Next: Satisfying two conditions? |