Hi,

Use NA() instead of "".
Or perhaps consider named ranges to only plot as far as is required.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mat" wrote in message
...
Hi

I am currently trying to create an excel line chart showing cumulative
baseline vs Cumulative Actual vs forecast actual lines (the forecast line
is
a continuation of the Actual to date line) which I have done - but am
trying
to automate it so it is 'more user friendly' and can be created at the
touch
of a macro.
The problem I am having is that one of the formulae i am using looks up a
date in the timescale and if it is in the future I want it to leave the
cell
bank (using the "" option" - problem is the chart then decides this is not
a
blank cell it is a zero and plots it accordingly. - Obviously I can "clear
the contents" afterwards to put the chart back to where it should be - but
is
there another option ?
Please help -all comments appreciated - is there any VB that can sort
this ?

Thanks in advance

Mat