Outstanding Add Projection Line Excel Graph

Under Chart Tools on the Design tab.

Add projection line excel graph. By default Excel adds the linear trendline into your chart. My original thinking was that I add a second line graph with the Y plot points for September 13 and the forecast number but I cant match them with the X plot points namely September 13 and Oktober 13 because they dont correspond. Click on the Insert tab on the overhead task pane Select Insert a SmartArt Graphic tool Under this choose the Process option.

There are lots of options in the tool. Excel immediately includes this new set of data in the graph. In the Forecast End box pick an end date and then click Create.

Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. In the Create Forecast Worksheet box pick either a line chart or a column chart for the visual representation of the forecast. In your graph double-click the target line.

But X-Y Plot. In order to add a horizontal line in an Excel chart we follow these steps. On the Analysis group click the Data Analysis icon.

Click Moving Average from the list and click OK. To add a horizontal line to your chart do the following. Click the plus icon found on the upper-right side of the chart.

Kutools for Excel - Includes more than 300 handy tools for Excel. Adding Highlighted Line Dummy to the Chart All you have got to do is add the dummy calculation to the chart and your chart should come up something like this Adding a Marker Calculations You might have noticed a red marker in the chart where the projections start. If you dont see the icon click the chart first Click 2.