+ Reply to Thread
Results 1 to 4 of 4

Pie Chart - Remove Legend labels that have no value

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Exclamation Pie Chart - Remove Legend labels that have no value

    Hi

    I have a table of data and some of the values are $-
    A pie chart is linked to this data - I know how to make the pie chart ignore the $- in the data labels but I need to figure out how to make it disappear from the Legend as well ?

    Anyone know how to do this?

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Pie Chart - Remove Legend labels that have no value

    http://www.andypope.info/charts/piezeros.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-12-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pie Chart - Remove Legend labels that have no value

    Thanks Andy - I have seen that before on another post but I cant really understand it and apply it to my spreadsheet...when I use the exact same formula as you have shown the legend labels still then just show as #NUM!

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Pie Chart - Remove Legend labels that have no value

    You need to post your file so we can attempt to see why the approach is not working for you

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1