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