+ Reply to Thread
Results 1 to 3 of 3

Skipping zero values redux!

  1. #1
    Registered User
    Join Date
    01-05-2009
    Location
    Washington, DC
    MS-Off Ver
    Excel 2003
    Posts
    3

    Skipping zero values redux!

    Okay, I know a lot has been posted about the way to skip zero or "non-entries" while plotting but I still can't resolve my situation. Let's say this is my data:
    Bart 3
    Lisa 7
    Homer 15
    Marge 2
    Maggie 0
    I created a new column using IF(formula = 0, NA(), formula) which gives me Bart 3 3
    Lisa 7 7
    Homer 15 15
    Marge 2 2
    Maggie 0 #NA
    So far, so good. The problem comes in plotting. I want to make a pie chart, not a line chart. On the line chart, it skips #NA like it should. On the pie, it still plots both the name and the "#NA" value. If you hover over it with the mouse, it shows up as 0%. I want this value ignored altogether as if it didn't exist. I don't want it the name on the legend or showing up on the chart. I have too much data which changes from month to month to be able to remove entries by hand. Any ideas?

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi,

    Welcome to the forum, take a look at Andy Pope's solution here

    http://www.andypope.info/charts/piezeros.htm
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    01-05-2009
    Location
    Washington, DC
    MS-Off Ver
    Excel 2003
    Posts
    3
    Thanks for the quick reply. I'm checking out the links now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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