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