No chart display of zero data

  • Thread starter Thread starter Terje Skogen
  • Start date Start date
T

Terje Skogen

I have a chart with month as X-axis (1-12) and a few series.
All the values in the series are calculated.
How can I avoid displaying values in the series if the values are 0?
I know this can be done if the cells are empty, and I have tried to
set in a value of a space if 0, but this is interpreted as 0 and
displayed.
Is there a way to set up the formulas to make the values in the cells
beeing interpreted as empty cells?
Any hints?

Regards
Terje
 
Hi
for charting purpose try returning NA() as a result of your fformula.
e.g.
=IF(your_formula=0,NA(),your_formula)
 
Perfect! Just what I needed.
Thanks!

Terje

Frank Kabel said:
Hi
for charting purpose try returning NA() as a result of your fformula.
e.g.
=IF(your_formula=0,NA(),your_formula)
Click to expand...
 
Back
Top