Simple Adding A Target Line In Excel Chart

Excel changed the Axis Position property to Between Tick Marks like it did when we changed the added series above to XY Scatter.

Adding a target line in excel chart. 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. So now you have a column chart in your worksheet like below. Here is a simple line chart with sales for January to June.

In the next chart a blue band with the target range has been added and you can quickly see which. How to add Target Line in Bar Chart Excel Advance Lecturesubscribe us. In the Series name box type the desired name say Target line.

Add a Target Range. Hover over the bottom right corner and click and drag the highlighted area of the table to extend the selection to the column Target. 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.

We need to show the target value as a horizontal line in the graph. Copy and paste the ff. Right click on the second series and change its chart type to a line.

Click OK twice to close both dialog boxes. PivotChart with target line. To add context to those numbers you can create an Excel line chart with target range.

The target line series is added to the graph orange bars in the screenshot below. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. Get the sample file here.