How to add target line to Excel chart

In this Excel charting tutorial, I will show you how to add a target line in an Excel chart.

To add a target line to an Excel chart, you can use the following steps:

First, create a simple chart showing the daily sales of a company, then create a simple bar graph for the same.

Data creation

This is the daily sales data for a company. As shown in the Excel file:

Daily Sales

Chart creation

Creating a simple bar chart from the Actual sale data:

Insert column chart

Clicking on the 2D clustered column chart:

Clustered column chart

Now Adding target sales data for the target line creation. Right-click the chart Area and click select Data:

Select Data

Click Add for the legend entries:

Legend entries

After clicking Add, select the series name by clicking on the cell with the name target sale and select series values from the column with target sales data:

Edit Series

And clicking ok:

Select Data Source

Now the target sales are added as columns, but we can change them to a target line by right-clicking the target series and changing the chart type:

Change Series Chart Type

Change option for Target sale to Line:

Line Target Sale

Click Ok:

Target Sale

To format the target line, right-click on the line and select “Format Data Series.” In the “Format Data Series” dialog box, select the “Line” tab and choose the line style, color, and width you want for the target line.

To add a label to the target line, go to the “Layout” tab on the Excel ribbon and click on the “Data Label” button in the “Labels” group. In the “Data Label” menu, select the “Values” option to show the target value as a label on the line.

See also  How to create a quarterly chart in Excel?

To make the target line stand out, you can change its color and style to make it more prominent. You can also add a label to the line to show the target value.

This is how to add a target line in an Excel graph trick in just a few steps.

Please find attached the Excel file or chart with the target line.