Nice Adding Target Line In Excel Chart

Next right click anywhere on the chart and click Select Data.

Adding target line in excel chart. Adding Target Lines to Charts Graphs in Excel 2016Check out my Channel for Dozens of Excel Tutorials. Then right click the target data series orange bars and choose Change Series Chart Type from the context menu in the Change Chart Type dialog box choose Line chart for the target data series from the Chart Type drop down list see screenshot. Beside the source data add a Benchmark line column and fill with your benchmark values.

Add a Horizontal Line. Seems easy enough but often the result is less than ideal. Get the sample file here.

This tutorial shows how to add horizontal lines to several common types of Excel chart. 2 Right-click on the existing chart and choose Select Data from the drop-down menu list. So now you have a column chart in your worksheet like below.

We need to show the target value as a horizontal line in the graph. Below are the steps you need to follow to create a chart with a horizontal line. Add a second series that contains your target value this can appear on the same excel sheet or a separate one The X value range for the second series is from 0 to 1 and the Y value corresponds to your target value 150 in the example file Select and copy the second series Right click your chart of interest select paste and then paste special.

In the chart shown in this example daily sales are plotted in columns and a line shows target. In order to add a horizontal line in an Excel chart we follow these steps. Excel How to Insert TargetGoal Line in Chart1.

Click in the Series value box and select your target values without the column header. Go To Insert Charts Column Charts 2D Clustered Column Chart. Select the chart and go to Design Select Data In the Select Data Source dialog box Click Add In the Edit Series box Type Series Name as Target Line and in Series Value select your Target Value cell This will insert a bar chart only for the first data point January.