I've seen a variant of this question asked a number of times, but none seem to deal with my particular problem. In my stacked bar chart I use a Series Name label. I'd like it to go away altogether when the value is 0.
Here is how it looks:
To get rid of the 0 value, I use the trick from here (and here, and here, and...) and change the number format to: #""%;;;
When I do that, the chart looks like this:
Still not what I want. I need the series name label to disappear as well as the call out box. I found two answers that recommended using a NA() to get rid of the label (here and here). I had to add a second row of labels and set the series label for the blue & orange bars separately, but still it didn't work. Here is the formula I used: =IF(D4=0,NA(),"Prefer Not to Answer")
So the first problem is why is it still displaying the error? If that is resolved the second problem will be whether or not the call out box disappears as well. Help?
