How to Add a Target Line in an Excel Graph

[@abc123ohio]

Perfect. Thank you!

[@abowles79]

Best tutorial, nice and clear and simple. Been hunting for a lesson this straight forward, well put together. Thanks-

[@Wesly17]

Thank you so much 😊👍

[@shoujomagic4273]

You saved my grade. The video was super clear and easy. Thank you xxx

[@sandramartinez8581]

Thank youuuuuu Sir! 😀

[@idhayaganthan9422]

thank you, best explanation.

[@sudharamaprasad7518]

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.?

[@getshakalu3322]

Thanks best explanation

[@hemantverma1241]

Great way of teaching

[@Perrygordo.n]

Thank you 🤎🧸🧺🫧

[@shizouka19]

Thank you!

[@andrehenry3212]

Thank you

[@VirendraSinghRajputGwalior]

Sir, Is it possible change the color of only those bars which has crossed target value

[@Craz1536]

Thanks for the info sir..

[@achilleonv]

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...

[@samhernandez5407]

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???

[@felipetobonconde5888]

Give this man a cookie.

[@kudamuyun3173]

Excellent tutorial with a great explanation. I must give 5 stars rating on this !!

[@aidans6274]

Excellent tutorial.

[@KamranMumtazAhmed]

There was no need for absolute reference in target column; I believe. Thanks for the video, it was really helpful. 🙂

[@santiagodonald9170]

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.

[@milesben7635]

@Santiago Donald instablaster =)

[@santiagodonald9170]

@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.

[@santiagodonald9170]

@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!

[@milesben7635]

@Santiago Donald You are welcome :D

[@eticalarohith8150]

lovely tutorial...

[@gautami6322]

Thank youuuu

[@tommyharris5817]

Brilliant. How do you make the chart independent of the table after you've created it?

[@un_abridged]

Thanks so much!! This makes it so easy

[@knowledgecentre2907]

very nice explaination

[@stevereed5776]

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?

[@poonam612]

This combo option is not coming on my template list?? What should I do??

[@MohammadHaroonHairan]

Thanks for the helpful video and great explanation.

[@naviplus9398]

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.

[@leeannatum1727]

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.

[@claytonryon9829]

very helpful for htis topic - the fastest and most accurate one i've seen - thank you!

[@m.akbarrizkial-fadhilah6353]

How to create it on Ms. Excel 2010?

[@Vision267]

is there a way to add a target value without adding a column to table

[@jonasherman9195]

Very well explained!

[@sereyroathchea5441]

how to extend the target bar?

[@ayamihamis2480]

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

[@danmg]

Excelent! Thanks for this!!

[@Ro_-hk4yz]

When i click on combo it only gives me 3 options and i cannot choose the series?? anyone else with this problem?

[@jannrobertson5879]

can the target values be different amounts?

[@kudamuyun3173]

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.

[@melindadasilva5006]

what if the target line more than one?

[@arshad1781]

Thanks

[@williamoneil5009]

thanks

[@labkktpl]

How to adjust/ expand the target line so that its touch the y axis

[@barry5766]

Did you find out how to do this?

[@labkktpl]

@@barry5766 No I didnt. Pls advice, Thanks!

[@crackedLCDsalvage]

@@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.

[@lewisclothier5496]

I think you can select on tick mark in axis formatting, it makes your X axis start from 0

[@SMGJohn]

Why not just colour one gridline?

[@sudharamaprasad7518]

Correction. How to format all elements of all the series in a graph in one shot?

[@nav0954]

👌🏼👌🏼