Table of Contents
To add a target line to your graph in Excel, you can use the “Line” chart type. Simply select the chart and go to the “Insert” tab, then select “Line”. In the dropdown menu, choose “Target Line” and then input the desired values into the fields provided. This will add the target line to your graph.
Occasionally you may want to add a target line to a graph in Excel to represent some target or goal.
This tutorial provides a step-by-step example of how to quickly add a target line to a graph in Excel.
Step 1: Create the Data
First, let’s create the following dataset that shows the total sales made by some company during various years:
Step 2: Add the Target Value
Now suppose that our target value for sales each year is 600.
To add this target line to a chart, we need to first create a target column that contains the value 600 in each row:
Step 3: Create the Graph with Target Value
Next, highlight the cells in the range B2:C10, then click the Insert tab, then click the icon called Recommended Charts within the Charts group.
In the new window that appears, click the tab called All Charts near the top and then click Combo:
Once you click OK, a bar graph with a target value will appear:
The blue bars represent the sales values for each year and the orange line represents the target sales value of 600 for each year.
Step 4: Customize the Graph (Optional)
The graph is now complete.