S
Stephen Robson
A colleague of mine is creating a chart that plots 3
series, based on a timeline (each day for 3 months or
so). One series has a value for each day (let's call this
the 'forecast' series). There are two other series that
only have values for the dates upto and including today
(<=now()). The source data is built using formulae in all
the cells, so Excel thinks there are values there. The
chart shows the forecast series fine, and shows the other
two with values up to today and then drops them down to
zero and continues the line. If I delete the formulae for
future dates the lines stop at today, but I need the
formulae there and not the lines (clear as mud). Is there
any way to do this?
Thanks
Stephen
series, based on a timeline (each day for 3 months or
so). One series has a value for each day (let's call this
the 'forecast' series). There are two other series that
only have values for the dates upto and including today
(<=now()). The source data is built using formulae in all
the cells, so Excel thinks there are values there. The
chart shows the forecast series fine, and shows the other
two with values up to today and then drops them down to
zero and continues the line. If I delete the formulae for
future dates the lines stop at today, but I need the
formulae there and not the lines (clear as mud). Is there
any way to do this?
Thanks
Stephen