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