![]() |
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? |
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? |
All times are GMT +1. The time now is 04:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com