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!
very wealthly as New Engineer, this took me 2 hours to understand, of which i didnt make it for many years. thanks for your sharing you make life easy. please share more engineering speadsheet pages
Really appreciate your instructions, very clearly spoken and presented! I was able to learn something I did not know existed before watching this video
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
@@AjayAnandXLnCAD Sorry, I wasn't meaning to have a go at you, your video is well explained and helpful, but it was meant to be a comment on Microsoft Excel!
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 !
Glad to hear that. Regarding Excel Chart with different Target points, I have done a video explaining 4 different charts of this type. Please go through videos section of this channel to find it.
As we are using the Error bar for the Target Line, we need to create the Legend Manually. You can add the definition for the Line using Text Box in the Insert Tab. Use the Insert shape in the same Tab to add a dotted line.
Hi Ajay. Great video, congratulations! Do you know a way to help me? I need to build a histogram graph with percentile line. Currently I'm drawing a line manually. Thanks.
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....
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.
Agreed, I have a chart I'm updating daily - using an error bar as a threshold line is a creative workaround, but isn't going to work for our needs without constantly updating.
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).
Thank you for the compliment. I got the value 0.5 after many tries and it worked for me. The point is, it can done, you just need to play with your values.
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.
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?
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?
Ajay An and, thank for your feedback, I 've make graph for gas chromatography, and daily key in result per lots from January until now, example the lot number is A001,A002,A003,A004,......,but now the graph lot number show A001,A003,A005...., I couldn't find result for A002,A004...I tried to adjust but it doesn't work, could it be the line graph lot number too many?
@@AjayAnandXLnCAD , yes it line graph, the lot number of the results around 200 more results, may be it a reason why some lot numbers result is hidden. Today I tried to do above lesson to my pc, but it won't work, because I used Microsoft 2010 version.
I don't have a copy of Excel 2010 to check it. The second method should work with almost every version of Excel. Moreover, to make the best out of Excel, I suggest you to move to Office 365 Subscription.
@@AjayAnandXLnCAD I totally agree! Many often forget the importance of remaining current. I suppose some corporations might be behind in rolling out updates & upgrades to their employees, so if you're out there & your Corp is asking you to complete data work with outdated data tools/software... Speak up! It will make your job easier & time spent less. :-)
Behind every successful engineer is an Indian dude on youtube. Thx 🙏🙏🙏
:)
This is so true. Thank you 😉
100% True.
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!
Thank you for the Tip and the awesome explanation.
Can you tell me why mine does not work when I specify and choose a whole column on a table as value? it still stays as a dot
very wealthly as New Engineer, this took me 2 hours to understand, of which i didnt make it for many years. thanks for your sharing you make life easy. please share more engineering speadsheet pages
Really appreciate your instructions, very clearly spoken and presented! I was able to learn something I did not know existed before watching this video
Glad it was helpful!
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
Excellent explanation! All the steps are very clear. Cheers from Colombia.
You are welcome!
THANK YOU! - 5 videos and 3 Websites later - - you nailed it
My pleasure :)
Your video saved a soul 🤣. Thanks a million
What a convoluted way to add a simple line to chart!
There are two methods explained, second one is much faster when when compared.
@@AjayAnandXLnCAD Sorry, I wasn't meaning to have a go at you, your video is well explained and helpful, but it was meant to be a comment on Microsoft Excel!
No worries :)
Just now saw your video...very very clear explanation..and subscribed your channel...keep going...all the best
Thanks you very much for this video! This was EXACTLY what I was looking for.
My pleasure 😀
Nice work. I appreciate your quality video and your excellent grasp of Excel and English.
Glad to hear that Sir ☺️
Absolutely comprehensive tutorial!
Thank you!
Excellent instructional video. Thank you for posting!
You are welcome!
Really appreciate for your instruction. Its very clear and easy understanding
Thank you, your explanation was so clear!
Glad it was helpful!
Very easily you have explain all the tricks👍👌
Thank you for the feedback
Thanks mate for helping us, really appreciate your works!
Glad I could help!
Thank you very much, you make my work much easier,
My pleasure 😀
My pleasure 😀
@@AjayAnandXLnCAD you know your work
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 !
Thank you sir🙏 you really helped me when I'm in trouble😢
Thank you very much! This is very well explained.
Glad to hear that. And thank you for leaving the feedback.
This guy know everything. Great.
Hi thanks for the great video
If the target is different to each person?
Glad to hear that.
Regarding Excel Chart with different Target points, I have done a video explaining 4 different charts of this type. Please go through videos section of this channel to find it.
Thank You Ajay! extremely helpful
My pleasure
Wow thank you so much for this
Its Very easy way to add a permisible limit in graphs with clearly voice,,,
Very helpful! Thank you!!!
My pleasure 😀
My pleasure 😀
Thank you so much. It was very helpful.
My pleasure 😀
thank you so much using this fro my research project to show margin of error
My pleasure 😀
Thanks Ajay. covered all the things related to it.
Thank you very much. This was indeed very helpful to me!
This is great. How would I format it to stay red until after it hits the target then go green??? Thanks so much.
Thanks for that awesome compliment and Great suggestion. I will do a video based on your idea.
Thank you, super helpful ❤
My pleasure 😀
A perfect tutor, thanks
Glad you liked it!
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?
As we are using the Error bar for the Target Line, we need to create the Legend Manually.
You can add the definition for the Line using Text Box in the Insert Tab. Use the Insert shape in the same Tab to add a dotted line.
This is wonderful and very creative. But is it possible to change to date instead of the names?
Suuuperb !!
Thank you, Dear !!💖💖💖
My pleasure.
Very good info, thanks for sharing
Thanks Ajay, helped a lot. Keep rocking.)
Thanks. Very helpful
It's very useful ... Thank you 😊
thank u very much . very useful
You are most welcome
Great tutorial!
Thank you for the compliment ☺️ Also I recommend you to check my latest video on Pictograph in Excel.
well explained video, very good job.
Thank you very much! I was looking for this tool.
My pleasure 😀
Thank you Ajay !!
You are the best!!
Thank you :)
Thank you so much. This helps me a lot !! :D
You're welcome!
Useful tips 👍🏻
Glad you think so!
Perfect, thank you
My pleasure
Excellent tutorial!
that was soo helpful. thanks a lot😄
Hi Ajay. Great video, congratulations! Do you know a way to help me? I need to build a histogram graph with percentile line. Currently I'm drawing a line manually. Thanks.
Very useful video..much appreciated 👍😊
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....
In the second method, I have created straight line a line graph using a single value.
Watch the video carefully, you will get it.
Excellent work
very good tricks thanks
My pleasure
Thank you so much for this videos
Thank you very much! I need this video!
My pleasure 😀
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
Thank you very much guy for this tutorial!
My pleasure 😀
Thank you. Amazing tutorial
My pleasure 😀
this is very useful video, thank you for sharing
My pleasure 😀
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.
Agreed, I have a chart I'm updating daily - using an error bar as a threshold line is a creative workaround, but isn't going to work for our needs without constantly updating.
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).
Thank you for the compliment.
I got the value 0.5 after many tries and it worked for me. The point is, it can done, you just need to play with your values.
Just subscribed!
Good information
Thank You!
The BEST!!!
Thanks soooo much 😊
So good!
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.
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?
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?
Hi Tiam, Sorry to say that I don't fully understand your problem. Can you be more specific?
Ajay An and, thank for your feedback, I 've make graph for gas chromatography, and daily key in result per lots from January until now, example the lot number is A001,A002,A003,A004,......,but now the graph lot number show A001,A003,A005...., I couldn't find result for A002,A004...I tried to adjust but it doesn't work, could it be the line graph lot number too many?
That can be a reason. Is it a line chart? and how many values are there?
@@AjayAnandXLnCAD , yes it line graph, the lot number of the results around 200 more results, may be it a reason why some lot numbers result is hidden. Today I tried to do above lesson to my pc, but it won't work, because I used Microsoft 2010 version.
Thankyou so much
Thanks!
Can this be done on a bar chart?
Yes. It is possible.
It is great!!!
Thank you
Thank you
You're welcome
Thank you for this video
im able to follow the steps but the whole graph changes when i change the target
When target will be different different?
I was unable to use this method in Excel 10, any suggestions.
I don't have a copy of Excel 2010 to check it. The second method should work with almost every version of Excel.
Moreover, to make the best out of Excel, I suggest you to move to Office 365 Subscription.
@@AjayAnandXLnCAD I totally agree! Many often forget the importance of remaining current. I suppose some corporations might be behind in rolling out updates & upgrades to their employees, so if you're out there & your Corp is asking you to complete data work with outdated data tools/software... Speak up! It will make your job easier & time spent less. :-)
Thanks
My pleasure :)
Thanks king
gracias
Super!!
I am trying to add data label on my target line, Its not happening
how to create table for target only one row that you did
thank youu
👏
Doesn’t work
Why 0.5
Trial and Error :)
This is just way too advanced. Should be way easier.
You should consider posting a suggestion at Excel UserVoice
Ajay Anand I mean there should just be a simple button ”add horizontal line or vertical line to graph”
How can they not realise that.
Thank you very much!