Sep 9, 2022 12:00 AM

Create Target Line for Excel Charts (Noob vs Pro Excel Trick)

External YouTube Channel

A target line or average line is a powerful visual that allows you to compare how actual data compares to their goal or budget.

Visualizing such a target line in a dynamic way in a Microsoft Excel chart is not that simple. Specially adding a target line to a bar chart. In this video I'll show you a super easy way to create such dynamic target lines for both a column chart and a bar chart.

In this Video

  • How to Add a Target Line to an Excel Chart
  • How NOT To Do It
  • Add Target Line to Column Chart in Excel
  • Add Target Line to Bar Chart in Excel

More about Target Line to an Excel Chart

How To Add a Target Line in Excel (Using Two Different Methods)

There are a variety of features you can use on Microsoft Excel to help display your data. A target line is a useful feature that allows individuals to see how their actual data compares to their initial goal.

Create Dynamic Target Line in Excel Bar Charts

If you are in the sales department and your life is all about targets, this charting technique is for you. And if you are not, read it anyway to learn some cool excel charting tricks.

How To Add Horizontal Benchmark/Target/Base Line In An Excel Chart

Let's say you have created a column chart to show four teams' sales amount in Excel. But now, you want to add a horizontal benchmark line in the chart, how could you handle it? This article will introduce three solutions for you!