Behind every successful engineer is an Indian dude on youtube. Thx 🙏🙏🙏

Absolutely comprehensive tutorial! Thank you!

Really appreciate your instructions, very clearly spoken and presented! I was able to learn something I did not know existed before watching this video

Thanks you very much for this video! This was EXACTLY what I was looking for.

Really appreciate for your instruction. Its very clear and easy understanding

THANK YOU! - 5 videos and 3 Websites later - - you nailed it

Thank you very much. This was indeed very helpful to me!

Thank You - very helpful. I was shocked though, that there are so many complicated and non-intuitive steps to achieve what I expected to be a simple task. Glad your vid was there

This is a very very good tip for adding thresholds to a graph chart. I actually tested it on a line chart (instead of a bar one) and it worked as well. I must add that you actually can turn the line length dynamic and automatic (based on the number of entries), by just right clicking on the line, choose Format Error Bars, select Custom on the Error Amount, and then click on Specify Value. Then, on the Positive Error Value you can select a whole column (for example). This way, you don't need to manually change the length of the line every time a new data entry is made. Nevertheless, this video rocks, so thank you so much for that, man!

Thanks Ajay. covered all the things related to it.

Thank you so much. It was very helpful.

This guy know everything. Great.

Excellent explanation! All the steps are very clear. Cheers from Colombia.

Just now saw your video...very very clear explanation..and subscribed your channel...keep going...all the best

Thank you Ajay !!

Excellent instructional video. Thank you for posting!

Thank you, your explanation was so clear!

Wow thank you so much for this

Very good info, thanks for sharing

Very well explained ! Thanks ! Would you be able to figure out how to insert a horizontal line in a stock chart ? It will be great if you can make a video on that. Thanks again !

Nice work. I appreciate your quality video and your excellent grasp of Excel and English.

Thank you very much! This is very well explained.

Thanks mate for helping us, really appreciate your works!

What a convoluted way to add a simple line to chart!

It's very useful ... Thank you 😊

Thanks. Very helpful

Thank You Ajay! extremely helpful

thank you so much using this fro my research project to show margin of error

Thank you very much!

well explained video, very good job.

Thanks Ajay, helped a lot. Keep rocking.)

Suuuperb !! Thank you, Dear !!💖💖💖

Very easily you have explain all the tricks👍👌

Thank you very much! I was looking for this tool.

Thank you so much. This helps me a lot !! :D

Excellent work

Thank You!

Perfect, thank you

So good!

The BEST!!!

Thank you very much guy for this tutorial!

Thanks soooo much 😊

Thank you. Amazing tutorial

A perfect tutor, thanks

Great tutorial!

Its Very easy way to add a permisible limit in graphs with clearly voice,,,

Very useful video..much appreciated 👍😊

Thankyou so much

Good information

thank u very much . very useful

Thanks!

Thank you for this video

Ajay.. Very nicely explained. Is it possible to make max & min line with same concept? not able add another x-error bar in same plot

You are the best!!

Just subscribed!

this is very useful video, thank you for sharing

very good tricks thanks

Useful tips 👍🏻

It is great!!!

This is wonderful and very creative. But is it possible to change to date instead of the names?

Hi If possible kindly advise on the below issue: I want to put grade in Y axis instead of numbers. My grades are excellent, good and satisfactory, where excellent means 3, good means 2 and satisfactory means 1. I want to make a chart to show an employee’s progress of five years, like an employee got good in 1st year and excellent in third year and so on. Will this be possible? It would be a great help. Thanks in advance.

Thank you

Ajay, thanks for the video. How do you add a legend displaying the red dotted lines? And adding the text which defines what the lines mean?

gracias

Hi, thanks for the video, easy to understand, thumps up for that. One question, I am using method 2 but unable to extend target line, can someone help please. Thanks....

Thanks king

This is great. How would I format it to stay red until after it hits the target then go green??? Thanks so much.

Thanks

Hi thanks for the great video If the target is different to each person?

What would you do if you used a dates as the x-axis? I am entering columns for every week and have the weeks categorized as text to reduce the space between the columns. Unfortunately, I believe that is making the target line not start at the left edge of the chart when I enter .5 as the value for the x-axis.

So this is great but messing up my chart, my chart has all months of the year but if you only have info for Jan and Feb the line still goes to 12 and your table does not auto adjust, could you tell me how I can take care of it?

Ajay great video but I have a doubt. Why you put 0.5 on X values data series? In my case yy-axis values are percentages. When I put 0.5, the plot goes too much for the right (doesn't center the plot like yours).

👏

im able to follow the steps but the whole graph changes when i change the target

I was unable to use this method in Excel 10, any suggestions.

Can this be done on a bar chart?

When target will be different different?

Hai Ajay, I need your help on excel graph for x axis data point won't show, for example the graph will show daily result until 1year, means the data point is more, but after I key in the result, the dot won't show, it should have show 123, but now the result on x axis show 13579... How to see x axis result for 2468?

how to create table for target only one row that you did

I am trying to add data label on my target line, Its not happening

Why 0.5

This is just way too advanced. Should be way easier.