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
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.
https://www.indeed.com/career-advice/career-development/how-to-add-target-line-in-excel
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.
https://trumpexcel.com/dynamic-target-line-in-excel/
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!
https://www.extendoffice.com/documents/excel/4974-excel-chart-add-benchmark-target-baseline.html