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

that can be done when the formula returns NA()

(not available)


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Par3" wrote:

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

Par3 wrote:
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?