| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I am trying to project out a line graph based on data
Hi,
I have made a line chart based on some data for a fiften year period. I would like to plot out the future points for a thirty year period based on this data. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I am trying to project out a line graph based on data
To perform a line projection, first click on the series the you would like to
forecast. Go to Chart - Add Trendline. The "options" tab will allow you to project the trend forward. You will probably want to use the "linear" option. It can also provide an equation which would allow you to manually calculate a future projection as opposed to using the trendline. -- John Mansfield http://cellmatrix.net "Lisa" wrote: Hi, I have made a line chart based on some data for a fiften year period. I would like to plot out the future points for a thirty year period based on this data. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a line graph based on a formula | Excel Worksheet Functions | |||
| Setting up data for a line graph | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| How can I get 7.3 million data pts on one line graph? | Excel Discussion (Misc queries) | |||
| How do I "index" data in a line graph? | Charts and Charting in Excel | |||
Hybrid Mode
