We're working on a chart at work to show compliance over a month. There are gaps in the data where the teams have lieu days etc. I personally like the interpolated option where it just connects the line graph up, however others prefer the gap between the data to show on the graph so that it highlights when teams weren't in. Is there anyway of getting the interpolated data to show as a dashed line or different to the actual data?

Oh, we're using Excel 2003 to do this.

I don't think so, nor in Excel 2007 either.

Try Golden Software's website, and ask them if Grapher can do this. It's only about $99 for a single user licence, less for for a multi-user I imagine, and a much better graphing package than Excel has ever been.

you could put the interpolated data in as a separate series and then delete that particular series from the legend. Just set it the same colour and change the style of the line.

That's going to be an utter nightmare of manual cut and paste; I presume Schern wants a "set up a chart style and feed it the data" solution for a monthly report.

Hmm, the method suggested by Trundlenut works, but it's a bit of a pain to setup. After the initial time spent creating the graphs it's only really a case of duplicating the actual data and then adding =NA() in the blank cells in the 2nd set of data for it to add the interpolated data but appearing as a dash, so that's a potential workaround.

Thanks for the advice both of you!