I want to generate two superimposed line charts to represent, during a
particular month:
a) forecast sales (accumulated)
b) actual sales as they are taken (accumulated)

I want to be able to directly compare the progress of actual sales with the
forecast, and a prediction of month end sales.

The forecast sales values and expected dates are entered at the start of the
month. The actual sales are entered daily by checking a separate resource and
entering sales values and corresponding dates. Multiple sales values may be
forecast and taken on the same date.

By the end of the month, in an ideal scenario, all the forecast sales values
will have been entered in the actual column at the forecast date and the
actual total will match the forecast total. In practice, however, the actual
dates may vary from the forecast dates, and perhaps not all the sales will
have been taken. The shortfall should be obvious from the chart.

This sounds to me like two separate charts, because although the range of
dates (month start to month end) is the same for forecast and actual, I can't
use a single column date range for both.

Any advice please?
I'm sure this must have already been done, but I've looked at online
templates and not found anything suitable.

I'm using Excel 2003.
--
Richard

Search the web and raise money for charity at www.everyclick.com