Removing Data Labels with zero value

swicked18 · May 15th 2015

Hello,

I am trying to make my bar graph not show data labels for anything that is a zero value. I get it to not show the value by formatting the number, but I would also like for it to not show the series name if the data equals zero. Any help would be greatly appreciated

SChalaev · May 16th 2015

Re: Removing Data Labels with zero value

My first thought was to use something like [White][=0]0.00; for data label formatting but looking at your chart and colours that are used, it's not an option.

Have you thought about using IF statements and NA() in your data table to eliminate series so they don't get plotted on the graph?

swicked18 · May 18th 2015

Re: Removing Data Labels with zero value

Can't believe I didn't think of the NA...works like a charm, thanks for the help

Removing Data Labels with zero value

Participate now!

Share