Set the formula to return NA() if you aren't in the current month.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"sarcastix" wrote:

I want to suppress chart points for a cumulative line graph of monthly
telephone costs where the particular month's values have not yet been entered
but there is a formula in the cell which currently returns null but will
return the value once it is posted on the accountmaster sheet.