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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart line style problem 1
creating mixed dashed and solid line charts 1
For "Marker Line Style" see Point.Format.Line.Weight 2
change color of curve line as time changes 2
Word Dashed line formatting 0
xy plot line style change when I select "fixed maximum" 1
Unwanted fills on lines in Office 2007 charts 2
Hide future month's linked cells with value of zero 9

Back
Top