Stunning Add A Threshold Line To Excel Graph
To add a horizontal line to your chart do the following.
Add a threshold line to excel graph. Enter the data for the vertical line in separate cells. The easiest way to get these new data in the chart is to double-click into the chart area to highlight all the data already shown in the graph. Or you can also use Alt F1 to insert a chart.
Right-click anywhere on the existing chart and click Select Data. Click the Analysis tab. Occasionally you may want to add a horizontal line to a scatterplot in Excel to represent some threshold or limit.
Right click on your scroll bar and select format control. Guglani asked on 8162010. In Series name select.
The Select Data Source dialog box will pop-up. In order to add a horizontal line in an Excel chart we follow these steps. 10 Comments 1 Solution 6451 Views Last Modified.
Clicking the Select Data option. In the Value field type a number that indicates the threshold value for the line. Add a new data series to your chart by doing one of the following.
I create the graphs in excel and paste in the. Add the cell or cells with the goal or limit limits to your data for example. Get the sample file here.