How to put a target line on an Excel chart?

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:

Daily Sales

Creating a simple bar chart from the Actual sales data:

Insert column chart

Clicking 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 cell with name target sale and select series values from 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 the same to target line by right clicking the target series and changing chart type:

Change Series Chart Type

Change option for Target sale to Line:

Line Target Sale

Click Ok:

Target Sale

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