Changing line appearance for future values

[RhysPieces]

Using Excel 2007. Is it possible to change the appearance of a line in a
chart for values in the future (like projections)? I would like to go from
solid to dashed and keep the same color and weight.

 

[Wigi]

Either you format line pieces individually (manual work).

Either you use 2 series to plot in the chart. Use IF functions to see on
which series a given value should be shown. Use NA() for values that should
not be plotted.

 

[Dave Curtis]

Hi,

You should just be able to add two trendlines for the same data points.
Add the first, extending it so many units into the future, and apply the
colour and dashed style.
Add another, but dont extend it into the future, and apply the same colour
but solid line style.

Dave

url:http://www.ureader.com/msg/10296496.aspx

 

[RhysPieces]

The first suggestion seems to imply one can select individual segments on a
line (e.g. a month) and format it manually. From what I see in Excel,
formatting is applied to the whole liine. How is it possible to select line
segments?
Also, I tried the second series idea but it is inserted in the chart at the
beginning of the year rather than at the beginnng month for the new series.
What causes that?

 

[David Biddulph]

Click twice on the relevant data point, firstly to select the data series,
but then secondly to select the data point, to enable Format Data Point
instead of Format Data Series.

 

[RhysPieces]

Thank you for the directions. After clicking once to select the line I moved
the mouse pointer between two markers and right-clicked to bring up the menu
that lets you format a point instead of the whole series.