How to Add a Target Line in an Excel Graph

Рет қаралды 333,932

Excel Tutorials by EasyClick Academy

Күн бұрын

In this video tutorial, we’ll have a look at how to add a target line in an Excel graph, which will help you make the target value clearly visible within the chart. Ready to start?
Don’t miss out a great opportunity to learn:
How to Make a Bar Graph in Excel
► • How to Make a Bar Grap...
How to Add Chart Elements in Excel
► • How to Add Axis Titles...
How to Use Absolute Cell Reference in Excel
► • How to Use Absolute Ce...
================
❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
KZfaq ► www.youtube.com/@ExcelTutoria...
================
⏱️Timestamps⏱️
0:00 Intro
0:30 How to Define a Target Value in a Graph
1:00 How to Fix the Cell Reference and Copy the Formula
2:08 How to Show the Target Value as a Horizontal Line in the Graph
3:19 How to Combine Two Types of Graphs
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
► kzfaq.info...
Transcription How to Add a Target Line in an Excel Graph
► www.easyclickacademy.com/how-...
Got Microsoft Office 365? Get it here
► www.easyclickacademy.com/buy-...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/34...
Voice over artist ► seanantonyvo.com
#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

Пікірлер: 54

@abowles79 Жыл бұрын

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

@abc123ohio 4 ай бұрын

Perfect. Thank you!

@shoujomagic4273 Жыл бұрын

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

@theunaBridgedversion 2 жыл бұрын

Thanks so much!! This makes it so easy

@idhayaganthan9422 7 ай бұрын

thank you, best explanation.

@aidans6274 2 жыл бұрын

Excellent tutorial.

@Wesly17 7 ай бұрын

Thank you so much 😊👍

@eticalarohith8150 2 жыл бұрын

lovely tutorial...

@shizouka19 Жыл бұрын

Thank you!

@Craz1536 Жыл бұрын

Thanks for the info sir..

@hemantverma1241 Жыл бұрын

Great way of teaching

@getshakalu3322 5 ай бұрын

Thanks best explanation

@knowledgecentre2907 3 жыл бұрын

very nice explaination

@Perrygordo.n Ай бұрын

Thank you 🤎🧸🧺🫧

@gautami6322 2 жыл бұрын

Thank youuuu

@andrehenry3212 5 ай бұрын

Thank you

@kudamuyun3173 2 жыл бұрын

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

@felipetobonconde5888 2 жыл бұрын

Give this man a cookie.

@sudharamaprasad7518 2 ай бұрын

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

@tommyharris5817 Жыл бұрын

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

@claytonryon9829 2 жыл бұрын

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

@jonasherman9195 2 жыл бұрын

Very well explained!

@danmg 2 жыл бұрын

Excelent! Thanks for this!!

@leeannatum1727 3 жыл бұрын

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.

@MohammadHaroonHairan 2 жыл бұрын

Thanks for the helpful video and great explanation.

@naviplus9398 2 жыл бұрын

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.

@arshad1781 3 жыл бұрын

Thanks

@williamoneil5009 3 жыл бұрын

thanks

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

@achilleonv 3 жыл бұрын

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 2 жыл бұрын

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

@KamranMumtazAhmed 3 жыл бұрын

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

@santiagodonald9170 2 жыл бұрын

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 2 жыл бұрын

@Santiago Donald instablaster =)

@santiagodonald9170 2 жыл бұрын

@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 2 жыл бұрын

@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 2 жыл бұрын

@Santiago Donald You are welcome :D

@poonam612 Жыл бұрын

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

@ayamihamis2480 2 жыл бұрын

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

@nav0954 Жыл бұрын

👌🏼👌🏼

@Vision267 Жыл бұрын

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

@m.akbarrizkial-fadhilah6353 2 ай бұрын

How to create it on Ms. Excel 2010?

@sereyroathchea5441 6 күн бұрын

how to extend the target bar?

@jannrobertson5879 2 жыл бұрын

can the target values be different amounts?

@kudamuyun3173 2 жыл бұрын

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.

@Ro_-hk4yz 4 ай бұрын

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

@melindadasilva5006 Жыл бұрын

what if the target line more than one?

@SMGJohn Жыл бұрын

Why not just colour one gridline?

@sudharamaprasad7518 2 ай бұрын

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

@labkktpl 3 жыл бұрын

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

@barry5766 3 жыл бұрын

Did you find out how to do this?

@labkktpl 3 жыл бұрын

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

@crackedLCDsalvage 3 жыл бұрын

@@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 2 жыл бұрын

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