Chart is recognizing "" data as 0

  • Thread starter Thread starter Lady Excel
  • Start date Start date
L

Lady Excel

Hello,

I am charting some line plots and in one column I have an IF statement that
makes a calculation if there is available data for the specific date/time. If
there is no data it leaves the cell blank (""). The plot is recognizing these
blank cells as 0.0 (zero), thereby causing the line to jump from x-axis to
point continuously. Any ideas of how I can fix this?
 
UNTESTED: Using the interpolate option answered in the other question,
change your formula to that it returns a #NA instead of zero:

If(yourCurrentFormula=0,NA(),yourCurrentFormula)
 
Back
Top