captain1974
Registered User.
- Local time
- Today, 19:34
- Joined
- Jan 15, 2007
- Messages
- 43
Access 2003.
I am trying to create a chart that has an x axis containing date values and I want that axis to extend past the last date and corresponding plot on the graph. The trendline will then extend into this forecasting area. For example, to predict sales or profit in the future.
There is an article by microsoft for how to do this with excel:
http://office.microsoft.com/home/video.aspx?assetid=XT010939811033&width=884&height=540&startindex=0&CTT=11&Origin=HA010929231033#
It appears that excel allows you to do this as part of the format trendline options, but there is no such option with access.
Does anyone know a way of doing this?
I am trying to create a chart that has an x axis containing date values and I want that axis to extend past the last date and corresponding plot on the graph. The trendline will then extend into this forecasting area. For example, to predict sales or profit in the future.
There is an article by microsoft for how to do this with excel:
http://office.microsoft.com/home/video.aspx?assetid=XT010939811033&width=884&height=540&startindex=0&CTT=11&Origin=HA010929231033#
It appears that excel allows you to do this as part of the format trendline options, but there is no such option with access.
Does anyone know a way of doing this?