Changing line appearance for future values
 

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.

Changing line appearance for future values
 

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.

Changing line appearance for future values
 

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

Changing line appearance for future values
 

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?

"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.

Changing line appearance for future values
 

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.
--
David Biddulph

"RhysPieces" wrote in message
...
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?

"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.

Changing line appearance for future values
 

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.

"David Biddulph" wrote:

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.
--
David Biddulph

"RhysPieces" wrote in message
...
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?

"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.