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