Neat Add Horizontal Line In Excel Chart

On the Chart Design tab in the Data group choose Select Data.

Add horizontal line in excel chart. 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. Go to tab Design on the ribbon. Press with left mouse button on Add Chart Element button.

Beside the source data add a Benchmark line column and fill with your benchmark values. Add the cell or cells with the goal or limit limits to your data for example. We use 25 for the Blank values and 0 for Target.

Next right click anywhere on the chart and click Select Data. Lets add two series to the chart Blank which will be a hidden area series and Target which will provide the horizontal line with its outline. Switch to the Marker section expand Marker Options change it to Built-in select the horizontal bar in the Type box and set the Size corresponding to the width of your bars 24 in our example.

Some of these charts need horizontal lines on them. Supposing you have created a column chart as below screenshot shown and you can add a horizontal average line for it as follows. Sometimes you need to add a horizontal line to your chart.

As it says I have a workbook actually a heap of workbooks that has the first sheet with 31 charts on it. View Profile View Forum Posts Registered User Join. We want to add a line that represents the target rating of 80 over the bar graph.

In the popup menu. Add a new data series to your chart by doing one of the following. Select the column chart and click Kutools Charts Add Line to Chart to enable this feature.