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?
Bookmarks