12.8 C
London
Tuesday, May 28, 2024
HomeSoftware TutorialsExcelHow to Add Target Line to Graph in Excel

How to Add Target Line to Graph in Excel

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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:

Excel add target line to chart

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)

Lastly, feel free to modify the colors, the style of the target line, and the axis labels to make the graph more aesthetically pleasing:

The graph is now complete.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Add Average Line to Bar Chart in Excel
How to Add a Horizontal Line to a Scatterplot in Excel
How to Add a Vertical Line to Charts in Excel

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories