+ Reply to Thread
Results 1 to 2 of 2

remove labels with a 0 value from axis in pie chart

  1. 01-22-2013, 07:00 PM #1
    ea223
    ea223 is offline
    Forum Contributor
    Join Date
    10-18-2012
    Location
    new york
    MS-Off Ver
    Office 365
    Posts
    177

    remove labels with a 0 value from axis in pie chart

    Is there a way to remove labels that represent a zero value from a 'legend' on a pie chart? So I have my data and I know how to remove zero data values from the pie chart but the labels still show up on the side in the legend. anyway to get rid of these?
    thanks
    Reply With QuoteRegister To Reply
  2. 01-23-2013, 05:30 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: remove labels with a 0 value from axis in pie chart

    custom number will remove Value data labels.

    If the data label shows multiple items use NA() in chart data source rather than zero.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1