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

Bryan wrote:
How can I show only valid data to date and not future data not yet entered
and considered by Excel as zeroes

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info