I have a PivotChart (pie type). I have formatted the Data Labels to show Category Name and Percentage. I'm wondering how to get Data Labels for say less than 1% to NOT show up. Is there a way to do this automatically instead of manually deleting each Data Point I don't want?
Thank you.
if you didn't have the category name you could use a custom number format but if you want that as well you would require code. this is one reason that people who specialize in data presentation regard pie charts as evil-you usually have to clutter the chart with labels for it to actually make any sense. a bar chart would often be a better solution
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks