Trendline excluding last 2 data points of series
 

Me again with more charting questions!

I have a column chart showing 6 months actual sales for a product followed
by the next two months forecast figures.

I want to show a trendline based only on the 6 months actual sales i.e. the
trend should not take into account our forecast. The trendline I normally
use is a linear trend.

Is there a way to do this?

Two ways to do it fairly easily
have a data set without your forecast. Plot it , set line and symbol to
none select the legend line it is on and clear all. set the trendline on
this set.

calculate the best fit equation for the data you wish to use and plot this
line as a separate series.

"Mary Ann" wrote:

Me again with more charting questions!

I have a column chart showing 6 months actual sales for a product followed
by the next two months forecast figures.

I want to show a trendline based only on the 6 months actual sales i.e. the
trend should not take into account our forecast. The trendline I normally
use is a linear trend.

Is there a way to do this?

Thank you bj. Ive used the first simpler option and its easy just as you
say.

"bj" wrote:

Two ways to do it fairly easily
have a data set without your forecast. Plot it , set line and symbol to
none select the legend line it is on and clear all. set the trendline on
this set.

calculate the best fit equation for the data you wish to use and plot this
line as a separate series.

"Mary Ann" wrote:

Me again with more charting questions!

I have a column chart showing 6 months actual sales for a product followed
by the next two months forecast figures.

I want to show a trendline based only on the 6 months actual sales i.e. the
trend should not take into account our forecast. The trendline I normally
use is a linear trend.

Is there a way to do this?