First of all, my experience with Excel charts is limited. Compounding
matters, most of my experience comes from generating charts through
VBA code.

Here is what I am trying to do: I have a multi-year project with
actual and expected expenditures. I have five columns of data

Date Projected Cumulative_Projected Actual Cum. Actual
1/1/08 10000 10000 9876
9876
2/1/08 9000 19000 9521
19388
3/1/08 9500


I have been asked to produce a chart (dates on horizontal axis, money
on vertical) that will chart a line of actual cumulative values and
then when actuals run out continue on with cumulative projected.
There needs to be a color break from actual to projected. In
addition, the series need to be connected so the first projected value
following actual data needs to be the same as the last actual data so
the line is continuous.

I have no problem displaying the graph of actual data as my first
series. However, no matter what I try I cannot get the chart of
projected data to start anywhere but the left side of the chart and I
need it to be shifted to the right to line up with the last datapoint
of actual expenditures.

If this is possible to do, some guidance on accomplishing this would
be appreciated.