Excel Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When plotting a chart which automatically updates, the last data entry is a
formula but will not have actual data until the information is entered on the
next week. On the chart it plots zero - how can I get the chart to not plot
this but yet have it included in my source data?
 
Hi,

The formula needs to use NA() rather than zero or "" for periods not yet
used. So your formula may look something like this,

=IF( <test> , <valuetouse> , NA() )

Cheers
Andy
 
Back
Top