Actual Vs Target charts are very popular to compare performance.
In this video tutorial, learn how to create a dynamic target line in a bar chart. The target line would allow you to visually show how many data points are above the target and how many are below the target.
You can change the target line using a scroll bar. It also shows how to change the color of the bars when the target is met.
A cool technique using Error bars in Excel.
Read all about it and download a working file from here: –
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Hi, bro what formula do you use for the cell F2 ?
Hi there – this is a great video! How do you get the words "Target Line" to disappear from the key at the bottom of the chart? Thank you!
Good video, but you can't do this on a pivot chart
Excellent
How to set target line in 3d chart excel 2010? Can any one help me….
Very nice video 👌
What if you are using a stackable chart?
Thank you Sumit for this great video. Good learning.
how you do target line for bar chart -your example is for column chart
Very nice and some handy stuff Sumit. Would be helpful to do similar but by having the chart created from a pivot table (not a standard table) as this is the most powerful way to display and manipulate the data; giving a full Pivot Chart and not a fixed chart. Can you show a dynamic target line on a Pivot Bar Chart?
hello is there a way to have a constant target line to a dynamic chart. more data is added and to a control target line
Great tips here thank you 🙂
Thank you very much for this video! It is very clear to understand, even for excel amateurs like myself.
I only had a slight issue because I am using percentage as my data value and when I link the scroll bar with the target line value it does not follow by the percentage I choose, because when I set the incremental change and page change they are not percentual values. Could you shed some light on this issue? Is it possible to work with percentages? Thank you very much!
hello, I need help, I trying to create the above formula with more columns but I getting #name? error. How can I create it?
thanks.
how i want to do if target in a range. i need your help.
Thank you for another great usefull tutorial to impress bosses, I am hooked on your videos, after seeing so many I am lost in registering in my mind. LOLZ. Now i am taking break.
Great thing, I am amazed, this is the first time I see a dynamic thing like this
Thank you
Excellent!
Thank you
Great Man!
Amazing 🙂 Thanks a lot.
Very well done.