How to eliminate zero values on graphs when formula calculates 0?

  • Thread starter Thread starter sjgolfer
  • Start date Start date
S

sjgolfer

I'm setting up a graph of data that is calculated with an "if" function over
a series of days of input data including future days. When the input data
cell is blank I would like the calculated value to not show a zero value on
the graph. If the cell were blank, the plot would not show a zero value.
The problem is that at the end of the line graph the line always falls off to
zero.
 
Thanks David. That does make the cell blank but unfortunately it still plots
as a zero on the graph.
SJgolfer
 
A value of #N/A (coming from the NA() function) is ignored by the chart
engine
Want to send me a sample file to check? Get me email from my website
best wishes
 
Problem solved. The cell were no empty but contained zeros and the
worksheet was formatted not to show zeros!
 
Back
Top