This video explains two methods to add a Target line to a column chart. Subscribe to the channel for more / ajayanandxlncad #ExcelChart #TargetLineExcel #ExcelColumnChart
Пікірлер: 128
@vodanh75143 жыл бұрын
Behind every successful engineer is an Indian dude on youtube. Thx 🙏🙏🙏
@AjayAnandXLnCAD3 жыл бұрын
:)
@ELJEYKANG3 жыл бұрын
This is so true. Thank you 😉
@Rosomyat2 жыл бұрын
100% True.
@adiprai28872 жыл бұрын
Absolutely comprehensive tutorial! Thank you!
@corvuscorax1424 жыл бұрын
Really appreciate your instructions, very clearly spoken and presented! I was able to learn something I did not know existed before watching this video
@AjayAnandXLnCAD4 жыл бұрын
Glad it was helpful!
@wasabi4u7249 ай бұрын
Thanks you very much for this video! This was EXACTLY what I was looking for.
@razifdimasardipa72202 жыл бұрын
Really appreciate for your instruction. Its very clear and easy understanding
@RobertLongM4 жыл бұрын
THANK YOU! - 5 videos and 3 Websites later - - you nailed it
@AjayAnandXLnCAD4 жыл бұрын
My pleasure :)
@targumasarem17283 жыл бұрын
Thank you very much. This was indeed very helpful to me!
@adampoyser64538 ай бұрын
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
@jayf48593 жыл бұрын
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!
@AjayAnandXLnCAD3 жыл бұрын
Thank you for the Tip and the awesome explanation.
@Oracleidol85 ай бұрын
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
@rajashekarabboju3 жыл бұрын
Thanks Ajay. covered all the things related to it.
@nareshsingrakhia34139 ай бұрын
Thank you so much. It was very helpful.
@ueharaai38842 жыл бұрын
This guy know everything. Great.
@juancamiloosorio76463 жыл бұрын
Excellent explanation! All the steps are very clear. Cheers from Colombia.
@AjayAnandXLnCAD3 жыл бұрын
You are welcome!
@sahanaramanathan1965 Жыл бұрын
Just now saw your video...very very clear explanation..and subscribed your channel...keep going...all the best
@lalitthapa0073 жыл бұрын
Thank you Ajay !!
@beauott84653 жыл бұрын
Excellent instructional video. Thank you for posting!
@AjayAnandXLnCAD3 жыл бұрын
You are welcome!
@ellakrystina4 жыл бұрын
Thank you, your explanation was so clear!
@AjayAnandXLnCAD4 жыл бұрын
Glad it was helpful!
@PayongKaibigan2 жыл бұрын
Wow thank you so much for this
@KamalRajJ2 жыл бұрын
Very good info, thanks for sharing
@rajnajat22 күн бұрын
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 !
@pointsofaccesswithphillipw36734 жыл бұрын
Nice work. I appreciate your quality video and your excellent grasp of Excel and English.
@AjayAnandXLnCAD4 жыл бұрын
Glad to hear that Sir ☺️
@martinhodge3944 жыл бұрын
Thank you very much! This is very well explained.
@AjayAnandXLnCAD4 жыл бұрын
Glad to hear that. And thank you for leaving the feedback.
@muhammadijmalkamil16293 жыл бұрын
Thanks mate for helping us, really appreciate your works!
@AjayAnandXLnCAD3 жыл бұрын
Glad I could help!
@gurtana4 жыл бұрын
What a convoluted way to add a simple line to chart!
@AjayAnandXLnCAD4 жыл бұрын
There are two methods explained, second one is much faster when when compared.
@gurtana4 жыл бұрын
@@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!
@AjayAnandXLnCAD4 жыл бұрын
No worries :)
@mahadesh39273 жыл бұрын
It's very useful ... Thank you 😊
@mzyilanjichisuse42262 жыл бұрын
Thanks. Very helpful
@johajrxoxo4 жыл бұрын
Thank You Ajay! extremely helpful
@AjayAnandXLnCAD4 жыл бұрын
My pleasure
@Namso100 Жыл бұрын
thank you so much using this fro my research project to show margin of error
@juanpabloazcuna97273 жыл бұрын
Thank you very much!
@thilinajayaratne99122 жыл бұрын
well explained video, very good job.
@kowshikraja.n1610 ай бұрын
Thanks Ajay, helped a lot. Keep rocking.)
@10morrisonka5 жыл бұрын
Suuuperb !! Thank you, Dear !!💖💖💖
@AjayAnandXLnCAD5 жыл бұрын
My pleasure.
@ExcelHindiTips5 жыл бұрын
Very easily you have explain all the tricks👍👌
@AjayAnandXLnCAD5 жыл бұрын
Thank you for the feedback
@pdhulpje75 ай бұрын
Thank you very much! I was looking for this tool.
@indyindzio3 жыл бұрын
Thank you so much. This helps me a lot !! :D
@AjayAnandXLnCAD3 жыл бұрын
You're welcome!
@AhmedAbouHalima3 жыл бұрын
Excellent work
@sudarshanjadhav16762 жыл бұрын
Thank You!
@dcifan49245 жыл бұрын
Perfect, thank you
@AjayAnandXLnCAD5 жыл бұрын
My pleasure
@kacontessoto2 жыл бұрын
So good!
@jeanieargo5022 жыл бұрын
The BEST!!!
@ransenmihindou38662 ай бұрын
Thank you very much guy for this tutorial!
@lalalalala11812 Жыл бұрын
Thanks soooo much 😊
@hassanlearning40863 ай бұрын
Thank you. Amazing tutorial
@natsamijoseph62413 жыл бұрын
A perfect tutor, thanks
@AjayAnandXLnCAD3 жыл бұрын
Glad you liked it!
@mohamedmorsy96514 жыл бұрын
Great tutorial!
@AjayAnandXLnCAD4 жыл бұрын
Thank you for the compliment ☺️ Also I recommend you to check my latest video on Pictograph in Excel.
@nidhityagi4335 Жыл бұрын
Its Very easy way to add a permisible limit in graphs with clearly voice,,,
@shahana99994 ай бұрын
Very useful video..much appreciated 👍😊
@rizkiaristyarini44183 жыл бұрын
Thankyou so much
@narayanjuti34032 жыл бұрын
Good information
@wissamrekab99633 жыл бұрын
thank u very much . very useful
@AjayAnandXLnCAD3 жыл бұрын
You are most welcome
@wesleyharper3253 Жыл бұрын
Thanks!
@deepakrajsrinivas7652 Жыл бұрын
Thank you for this video
@suneelpermarody3 жыл бұрын
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
@yvetloayzadelcarpio59663 жыл бұрын
You are the best!!
@AjayAnandXLnCAD3 жыл бұрын
Thank you :)
@dekass79652 жыл бұрын
Just subscribed!
@athanasalois47148 ай бұрын
this is very useful video, thank you for sharing
@FaysalEasyExcel4 жыл бұрын
very good tricks thanks
@AjayAnandXLnCAD4 жыл бұрын
My pleasure
@HungryWorld73 жыл бұрын
Useful tips 👍🏻
@AjayAnandXLnCAD3 жыл бұрын
Glad you think so!
@gersonbanda77924 жыл бұрын
It is great!!!
@AjayAnandXLnCAD4 жыл бұрын
Thank you
@lawrencelim8674Ай бұрын
This is wonderful and very creative. But is it possible to change to date instead of the names?
@wassupbeauty73312 жыл бұрын
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.
@choicruz94974 жыл бұрын
Thank you
@AjayAnandXLnCAD4 жыл бұрын
You're welcome
@ClubLongshao4 жыл бұрын
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?
@AjayAnandXLnCAD4 жыл бұрын
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.
@angelmamanisucapuca76903 жыл бұрын
gracias
@rugvedk4 жыл бұрын
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....
@AjayAnandXLnCAD4 жыл бұрын
In the second method, I have created straight line a line graph using a single value. Watch the video carefully, you will get it.
@dhayalzahrani49796 ай бұрын
Thanks king
@jbkregs27664 жыл бұрын
This is great. How would I format it to stay red until after it hits the target then go green??? Thanks so much.
@AjayAnandXLnCAD4 жыл бұрын
Thanks for that awesome compliment and Great suggestion. I will do a video based on your idea.
@sahinhossainmolla35654 жыл бұрын
Thanks
@AjayAnandXLnCAD4 жыл бұрын
My pleasure :)
@clikon20123 жыл бұрын
Hi thanks for the great video If the target is different to each person?
@AjayAnandXLnCAD3 жыл бұрын
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.
@michaeljohnston97133 жыл бұрын
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.
@robhimself33 Жыл бұрын
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.
@Oracleidol85 ай бұрын
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?
@LordNapuka4 жыл бұрын
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).
@AjayAnandXLnCAD4 жыл бұрын
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.
@tessyjacob6260 Жыл бұрын
👏
@mimme8649 ай бұрын
im able to follow the steps but the whole graph changes when i change the target
@lovejoygirl4 жыл бұрын
I was unable to use this method in Excel 10, any suggestions.
@AjayAnandXLnCAD4 жыл бұрын
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.
@stephaniecallaway7984 Жыл бұрын
@@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. :-)
@rkb574 жыл бұрын
Can this be done on a bar chart?
@AjayAnandXLnCAD4 жыл бұрын
Yes. It is possible.
@md.ziaurrahman14522 жыл бұрын
When target will be different different?
@tiamhokwee74944 жыл бұрын
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?
@AjayAnandXLnCAD4 жыл бұрын
Hi Tiam, Sorry to say that I don't fully understand your problem. Can you be more specific?
@tiamhokwee74944 жыл бұрын
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?
@AjayAnandXLnCAD4 жыл бұрын
That can be a reason. Is it a line chart? and how many values are there?
@tiamhokwee74944 жыл бұрын
@@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.
@capitalaccountdept48642 жыл бұрын
how to create table for target only one row that you did
@lipsalopamudrasahu8393 Жыл бұрын
I am trying to add data label on my target line, Its not happening
@kudamuyun31733 жыл бұрын
Why 0.5
@AjayAnandXLnCAD3 жыл бұрын
Trial and Error :)
@vika01944 жыл бұрын
This is just way too advanced. Should be way easier.
@AjayAnandXLnCAD4 жыл бұрын
You should consider posting a suggestion at Excel UserVoice
@vika01944 жыл бұрын
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.