I don't want to graph "null" values?

  • Thread starter Thread starter jfinney
  • Start date Start date
J

jfinney

I am plotting values over time using Excel's graphing feature. The graph
takes data from an adjacent worksheet. I have defined the graph to take data
from a large range in the work sheet but not all cells have data in them. I
add one piece of data each day to the spreadsheet. The new point is graphed
each day. However, all of the null cells following my last point are also
plotted as zero. These cells have a "null" value in them not the number
zero. How can I stop my plotted graph with the last numerical value?
Thanks, Jim
 
Go to Tools - Options - Chart.
Select: Plot empty cells as "Not Plotted (leave gaps)"

Note that if your blank cells are actually formulas, you need to have the
formula return NA() instead of "".
 
Back
Top