You have a couple choices. If you want to keep just a single series, select one by
one each segment you want to change (tow single clicks: one to select the series,
the next to select a point and line segment). Press CTRL+1 to bring up the
formatting dialog, and make your changes. Select the next segment and repeat (or
press the F4 key to repeat).

Choice 2 uses 2 series, with data as shown:

Actual Projected
2000 100
2001 150
2002 200
2003 250
2004 300
2005 350 350
2006 425
2007 500

All blank cells here must be blank, including the top left cell. Make your line
chart with this set of data, and format the two series differently.

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

odcltd wrote:

I have an Excel chart, a line graph with 10 data sets charted on it. The
time scale is 2000 to 2007 and I'd like the forecast data, i.e. 2005 to 2007
to be dotted.

Therefore the line should be solid to 2004, then dotted thereafter. Is
there an easy way to create such a line?

I'm using Office Excel 2003 v11.5