How to Add a Target Line in an Excel Graph

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 Add Chart Elements in Excel

How to Use Absolute Cell Reference in Excel

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️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! :)

Transcription How to Add a Target Line in an Excel Graph

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[abowles]

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

[shoujomagic]

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

[sudharamaprasad]

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

[kudamuyun]

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

[KamranMumtazAhmed]

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

[un_abridged]

Thanks so much!! This makes it so easy

[MohammadHaroonHairan]

Thanks for the helpful video and great explanation.

[VirendraSinghRajputGwalior]

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

[tommyharris]

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

[claytonryon]

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

[leeannatum]

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.

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

[stevereed]

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?

[naviplus]

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.

[poonam]

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

[Vision]

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

[ayamihamis]

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

[jannrobertson]

can the target values be different amounts?

[Ro_-hkyz]

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