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