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.



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"RhysPieces" wrote:

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.