Formidable Add A Straight Line In Excel Graph

To add a dotted forecast line in an existing line chart in Excel please do as follows.

Add a straight line in excel graph. This will select the line and open the Format Data Series pane on the right side of your Excel window. So now you have a column chart in your worksheet like below. Click once anywhere inside the graph area.

We will tabulate our data in two columns. 1Beside the source data add a Forecast column and list the forecast sales amount as below screenshot shown. To achieve this effect add a line to your chart as explained in the previous examples and then do the following customizations.

Or you can also use Alt F1 to insert a chart. In Excel 2013 Excel 2016 Excel 2019 and later select Combo on the All Charts tab choose Scatter with Straight Lines for the Average series and click OK to close the dialog. To add a vertical line to your line or scatter chart do the following.

Next right click anywhere on the chart and click Select Data. Eg this will be useful to show data and highlight a current date. Add a new data series to your chart by doing one of the following.

Eg this will be useful to show data with some goal line or limits. We can draw a vertical line on the chart manually but thats just not smart. Add the date with the current date to your data for example.

The resulting line extends to the edges of the plotted area but Excel changed the Axis Position to Between Tick Marks. We would like to add vertical lines dynamically to mark a certain data point say the max value. To add a new data series to your chart do one of the following.