eliminate future zeroes

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

How can I show only valid data to date and not future data not yet entered
and considered by Excel as zeroes
 
Hi,

Future data cells should be empty.
If they contain formula then the result for empty data should be NA()
rather than "". Charts treat text values, which "" is, as zero.
NA() will only stop the data marker being plotted. The line will be
interpolated between valid data points. But as your future points will
not contain any valid points the line will stop.

Cheers
Andy
 
Back
Top