Casual Excel Chart Prediction Line

The Format Trendline menu will open on the right.

Excel chart prediction line. The bands become lighter as the distance from the prediction line increases. The chart type is set to line chart and actual and forecast values are plotted as two data series. The data used for the chart is set up as shown below.

Kutools for Excel - Includes more than 300 handy tools for. To finish the line chart youll remove the legend and add a label to the last data point in each series. Its useful for forecasting sales stock requirements trends etc.

To run the regression arrange your data in columns as seen below. In Excel 2003 and earlier it is easy and straightforward to add high-low lines to a set of line chart series. The Linear trendline option will already be selected.

Create a new series for each line with just two points for each series. Lets customize this line chart. By doing this Excel does not recognize the numbers in column A as a data series and automatically places these numbers on the horizontal category axis.

On the Format Trendline pane select Moving Average and specify the desired number of periods. Click on the Options tab and check the High-Low Lines box. Right-click the data series and click Add Trendline.

In the Forecast End box pick an end date and then click Create. From the Trendline menu select Linear Trendline. Only if you have numeric labels empty cell A1 before you create the line chart.