Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|