I am trying to create a running chart whereby information is added daily.
The information, as added, is run though a formula and is added to the chart.
I want only the new information to plot on the chart, not the cells where
information has not been added. The problem I am having is that the cells
where the information has not been added are plotting as "zero". I have the
option checked where it will "not plot empty cells", but since the cells
where data has not been entered contains a formula, it is not recognizing
this as an empty cell and plots it as zero. Is there a function that I can
use to tell the chart not to plot the formula as "zero"?