Is this the only way to add a goal line in excel? It is so easy in other programs like Minitab, but it is a pain the butt for excel. Why do I need an entire column just for a goal line. It makes sense if the goal is moving, but if it is static for the given time frame then it should be much easier to insert. I work with data that is 6-9000 data points a day. Over the course of a month I can have 250k data points. I have had to use another column for 250k rows just to show a static goal...
this is exactly my issue, it's incredibly inefficient, why cant i just use the cell at the bottom of the chart that i alread have with the average in it???
sorry to be offtopic but does someone know a way to log back into an instagram account? I stupidly lost the account password. I appreciate any tips you can give me.
@Miles Ben thanks for your reply. I got to the site through google and im trying it out now. Seems to take a while so I will get back to you later when my account password hopefully is recovered.
Its depend on yr statistics application. I havent seen different target in the group of number or data. Coz target usually refer to specific value in the group of number.
@@labkktpl @Barry you could add empty rows for the desired series on each side - so that your data series is in between these empty rows. Of course, add the threshold value in this empty row. Hope it makes sense.
Best tutorial, nice and clear and simple. Been hunting for a lesson this straight forward, well put together. Thanks-
Perfect. Thank you!
You saved my grade. The video was super clear and easy. Thank you xxx
Thank you so much. It was useful. Can you tell me how I can format all the series in a given graph for line colour, marker, size, etc.?
Thank you so much 😊👍
thank you, best explanation.
Is this the only way to add a goal line in excel? It is so easy in other programs like Minitab, but it is a pain the butt for excel. Why do I need an entire column just for a goal line. It makes sense if the goal is moving, but if it is static for the given time frame then it should be much easier to insert. I work with data that is 6-9000 data points a day. Over the course of a month I can have 250k data points. I have had to use another column for 250k rows just to show a static goal...
this is exactly my issue, it's incredibly inefficient, why cant i just use the cell at the bottom of the chart that i alread have with the average in it???
Great way of teaching
Thank youuuuuu Sir!
😀
Give this man a cookie.
Thanks best explanation
Sir, Is it possible change the color of only those bars which has crossed target value
Thank you 🤎🧸🧺🫧
Thank you!
Thank you
Excellent tutorial with a great explanation. I must give 5 stars rating on this !!
Thanks for the info sir..
Mil gracias
Excellent tutorial.
Brilliant. How do you make the chart independent of the table after you've created it?
There was no need for absolute reference in target column; I believe. Thanks for the video, it was really helpful. 🙂
sorry to be offtopic but does someone know a way to log back into an instagram account?
I stupidly lost the account password. I appreciate any tips you can give me.
@Santiago Donald instablaster =)
@Miles Ben thanks for your reply. I got to the site through google and im trying it out now.
Seems to take a while so I will get back to you later when my account password hopefully is recovered.
@Miles Ben It did the trick and I now got access to my account again. I'm so happy!
Thanks so much, you saved my account!
@Santiago Donald You are welcome :D
Thank youuuu
lovely tutorial...
What if I select a few months at a time and would like the average for those. In this case depending on selection of months average value changes.
This combo option is not coming on my template list?? What should I do??
Great video, however, i'm trying to add a target line to a waterfall chart and this method doesn't seem to work, any ideas?
Thanks so much!! This makes it so easy
My keyboard has FN KEY which has blue color, when I try to click FN + F4 DOESN'T WORK.
what alternative way in order to make target line
Thanks for the helpful video and great explanation.
is there a way to add a target value without adding a column to table
very nice explaination
How to create it on Ms. Excel 2010?
can the target values be different amounts?
Its depend on yr statistics application. I havent seen different target in the group of number or data. Coz target usually refer to specific value in the group of number.
Excelent! Thanks for this!!
how to extend the target bar?
Thanks for the help with my homework. Wasn't sure how to show that average line until I watched this video. Thanks for the help.
Very well explained!
How to adjust/ expand the target line so that its touch the y axis
Did you find out how to do this?
@@barry5766 No I didnt. Pls advice, Thanks!
@@labkktpl @Barry you could add empty rows for the desired series on each side - so that your data series is in between these empty rows. Of course, add the threshold value in this empty row. Hope it makes sense.
I think you can select on tick mark in axis formatting, it makes your X axis start from 0
very helpful for htis topic - the fastest and most accurate one i've seen - thank you!
When i click on combo it only gives me 3 options and i cannot choose the series?? anyone else with this problem?
what if the target line more than one?
Why not just colour one gridline?
Thanks
thanks
👌🏼👌🏼
Correction. How to format all elements of all the series in a graph in one shot?