I am using bar charts.

I have made two data series for the same thing just to change color for negative and positve bars. I used if(a1>0,a1,"") for positive numbers and if(a1<0,a1,""). and then put the bars at 100% overlap. It worked fine.

BUT !!

When i insert the data labels. it shows 2 data labels for every same, one is 0% and one with the actual coming from the series. I tried to work it out but can't and want your help.

What i want is that, it should show only labels for the numbers coming from the series and not the zeros arising from "" or NA().


Please help me.