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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
