How To Put A Target Line On An Excel Chart

How To Put A Target Line On 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.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References