dynamic series (Excel 97)


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?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads