Casual Excel Chart Add Threshold Line

Reselect the data series and now change series chart type to line.

Excel chart add threshold line. Now its time to move that benchmark data from bars to a line. To add a horizontal line to your chart do the following. Select the entire table and insert a line chart with markers.

Now enter a value 100 for Jan in Ver Line column. 10 Comments 1 Solution 6451 Views Last Modified. Copy the data select the chart and Paste Special to add the data as a new series.

Add the date with the current date to your data for example. The Edit Series dialog box will pop-up. I am creating a powerpoint pres and in which I am copy pasting graphs from an excel sheet.

Add the cell or cells with the goal or limit limits to your data for example. Guglani asked on 8162010. The resulting line extends to the edges of the plotted area but Excel changed the Axis Position to Between Tick Marks.

To do this we can create a fake data series that shows the minimum and maximum value along the x-axis 0 and 20 as well as two y-values that are both equal to 20. This will select the line and open the Format Data Series pane on the right side of your Excel window. Beside the source data add a Benchmark line column and fill with your benchmark values.

To add a new data series to your chart do one of the following. In Series name select. Get the sample file here.