Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mikelee101
 
Posts: n/a
Default Trendlines and Forecast

Hello,
I have a set of data that I'm charting, which has the most recent data at
the top of the table. For example:

Month Units
Apr 350
Mar 275
Feb 325
Jan 365

In order to chart it so that the timeline goes from left to right, I'm using
the "Categories in Reverse Order" option.
I also have a linear trendline that I want to forecast out 3 periods.
However, since I've reversed the x-axis order, the forecast is going on the
wrong end of the data. I tried the Forecast Backward option, but it wouldn't
let me go above .5 of a period.
Does anyone know how to trick the trendline to forecast off the top of the
table as opposed to the bottom of the table?

Thanks for the help.

Mike

(xl2000, winxppro)
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Mike,

One option would be to totally omit the use of the built-in charting
trendline. As the alternative, use Excel's built-in functions to create the
trend line via worksheet cells. After the trend has been created in your
woksheet, chart it as another series just as you would your original data.

----
Regards,
John Mansfield
http:www.pdbook.com

"mikelee101" wrote:

Hello,
I have a set of data that I'm charting, which has the most recent data at
the top of the table. For example:

Month Units
Apr 350
Mar 275
Feb 325
Jan 365

In order to chart it so that the timeline goes from left to right, I'm using
the "Categories in Reverse Order" option.
I also have a linear trendline that I want to forecast out 3 periods.
However, since I've reversed the x-axis order, the forecast is going on the
wrong end of the data. I tried the Forecast Backward option, but it wouldn't
let me go above .5 of a period.
Does anyone know how to trick the trendline to forecast off the top of the
table as opposed to the bottom of the table?

Thanks for the help.

Mike

(xl2000, winxppro)

  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Mike -

If you use real dates: April 1, 2004 etc., Excel will plot in increasing
date order. You can extend it forward (beyond April) indefinitely.
Apr 350
Mar 275
Feb 325
Jan 365

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

mikelee101 wrote:

Hello,
I have a set of data that I'm charting, which has the most recent data at
the top of the table. For example:

Month Units
Apr 350
Mar 275
Feb 325
Jan 365

In order to chart it so that the timeline goes from left to right, I'm using
the "Categories in Reverse Order" option.
I also have a linear trendline that I want to forecast out 3 periods.
However, since I've reversed the x-axis order, the forecast is going on the
wrong end of the data. I tried the Forecast Backward option, but it wouldn't
let me go above .5 of a period.
Does anyone know how to trick the trendline to forecast off the top of the
table as opposed to the bottom of the table?

Thanks for the help.

Mike

(xl2000, winxppro)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"