Your data is like

actual projected
1-jan-07 100 0
2-jan-07 110 0
3-jan-07 0 120
4-jan-07 0 130

so you have a line in the actual series from {2-jan-07, 110} to {3-jan-07,
0}, which slopes downward, and another in the projected series from
{2-jan-07, 0} to {3-jan-07, 120}, which would slope upwards, except it
nicely fills in next to the downward sloping line.

Keeping a time-scale axis, change your data like this, so you have two
points for each series on the date where the vertical transition belongs:

actual projected
1-jan-07 100 0
2-jan-07 110 0
2-jan-07 0 110
3-jan-07 0 120
4-jan-07 0 130

The lines are now defined at {2-jan-07, 110} to {2-jan-07, 0} and {2-jan-07,
0} to {2-jan-07, 110}, with both endpoints on the same date, thus they are
vertical.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______



"Ken Snyder" wrote in message
...
For a project I'm working on I have an area graph that has two series
(actual
data and projected data). As the x-axis has weekly data i'd like the point
of
the "actual data" to flow right into the "forecasted data". This works but
for some bizarre reason the vertical line that separates these two areas
is
not purely vertical but slants backward to the left.

Probably best to show a picture of this. I've posted it he
http://ken.net/images/WonkyAreaGraph.jpg

Any help would be appreciated.