Charting forecast and actual data

[Purple_Mona]

Hi there,
I have been trying to create a line chart where actual turnover (for years 2000-2008) will be a smooth line and the forecast (for years 2009-2013) will be a dashed line. However, this needs to be denoted by one line (part smooth and part dashed).
Can anyone help?? Have been trying to google it all morning but there's not much on the web!!
thanks!!

 

[GlennUK]

Just have 2 series, one for actual and one for forecast. Have the end of the actual series ( years 2009-2013 ) be #NA! entries ( formula =NA() ) and have the beginning of the forecast series ( years 2000-2007 ) be #NA! entries, ( and have 2008 of forecast series be 2008 actual if you don't want a gap in the line ). Format the lines as required, and it should look how you want.

 

[Purple_Mona]

Glenn,
Works great. Thanks!