Simple Add Threshold Line To Excel Chart
Click Kutools Charts Add Line to Chart to enable this feature.
Add threshold line to excel chart. Right click on your scroll bar and select format control. On the All Charts tab select Combo. We also adjust the formatting of the table to make it consistent and move on.
Select the chart you will add benchmark line for. You have the banded chart with the actual results plotted above it. So now you have a column chart in your worksheet like below.
Right click on anywhere on the bar chart and click format data series and reduce gap width to 0. Adding a series data. In the Select Data Source dialog box click.
Click in the Series value box and select your target values without the column header. Add a new data series to your chart by doing one of the following. Link your scroll bar.
Add Threshold Line Excel. Right-click in the chart area and choose Select Data. Reselect the data series and now change series chart type to line.
Click the chart title and then select Edit. In the Static Thresholds section click Add Threshold Line. Lets insert another column next to the column Sales and name it Target.