In this Article I will guide you to add a target line in an excel chart.

First we will create a simple chart showing the daily sales of a company and we will create a simple bar graph for the same.

Data creation:

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

Creating a simple bar chart from the Actual sales data:

Clicking 2D clustered column chart:

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

Click Add for the legend entries:

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

And clicking ok:

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

Change option for Target sale to Line:

Click Ok:

You can add legends if not shown. Please find attached the Excel file or chart with target line.