predict future data

[Jeff]

Is there a way to create an XY line graph wih plotted
data, yet leave room to predict future data on the axes?
I can get the graph, but the x and y axes stop at the last
data points, and I want those axes continued so that the
existing data can be examined and future data predicted
and plotted on the same graph, but I am not sure how to
accomplish this. Any suggestions would be appreciated.
Thanks.

Jeff

 

[Bernard Liengme]

1) Click on data series in chart, use Add trendline; in Option tab specify
some units forward
OR
2) Read Help about TREND and FORECAST, and SLOPE and INTERCEPT
OR
3) Get crystal ball (sorry!)

 

[Jon Peltier]

Jeff -

You can extend the Y axis by double clicking on it and changing the
Maximum setting on the Scale tab. The X axis works the same way if you
have an XY Scatter chart (not Line chart), or if it's a Line chart with
a time-scale axis.

- Jon