Changing line appearance for future values

  • Thread starter Thread starter RhysPieces
  • Start date Start date
R

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.
 
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.
 
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?
 
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.
 
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.
 
Back
Top