Thank you Andy. Since making this post I came across another post that
helped me, and there is another way of doing this, which is simply to stick
to one series, to highlight the whole line on the chart and then to click
again to select the individual segment you want (I didn't realise you could
do this). You can then change the format of just that part of the line. I
think the guy who first created the chart must have done this, because there
only seems to be one data series.

"Andy Pope" wrote:

Hi Karen,

Here is an example of what Earl was describing.
http://www.andypope.info/ngs/ng45.htm

Cheers
Andy

Karen Saberi wrote:
I tried doing that at one stage, but then found that I had two lines, rather
than a single time series, with the X-axis only showing labels for the years
with the actual, rather than projected data. Is there any way of avoiding
this happening?

"Earl Kiosterud" wrote:


Karen,

Put your projected data in a separate series (probably a separate column,
depending on how your data is laid out).
--
Earl Kiosterud
www.smokeylake.com

"Karen Saberi" wrote in message
...

I would like to be able to format a single line in a chart (representing
the
time period 2002 to 2010) to be solid for actual data and dotted for
projected data, but I only seem to be able to change the format of the
entire
line. Can anybody out there help me?




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info