HomeОбразованиеRelated VideosMore From: Eugene O'Loughlin

How To... Add an Average Line to a Line Chart in Excel 2010

284 ratings | 108506 views
Learn a simple way to add a line representing the average value on a line chart (this also works for other types of chart). There is no tool in Excel to do this, so you will have to be able to use a simple work-around to insert a line.
Html code for embedding videos on your blog
Text Comments (33)
Enyioma Oguama (24 days ago)
Great one to follow. thanks
Eric Schau (29 days ago)
Thank you for the informative video! It was a great help and easy to follow.
prefontainesi (2 months ago)
At 50 seconds... I just can't believe Excel doesn't have this function easily accessible!! It's absurd!!
Yourewelcome. CA (2 months ago)
Terrific! Thank you Eugene. I'm using Excel 2018 in a Mac and worked perfect
Sandhya Banik (4 months ago)
Simply explained and quiet helpful.... Thanks a lot prof.
Predator32 (7 months ago)
Is that you Roy from the IT Crowd?
Abu Ayub Anssary (1 year ago)
very helpful indeed
Joseph Sleiman (1 year ago)
Thank you! I have a problem. I am trying to do the same, only my X-values of time are not equal in terms of intervals, and so I cannot calculate the average by simply giving each "tech support call" value it's equal impact to the average. Is there a way to calculate this average , taking into account irregular X-time values. For example : Two sets with same calls values but over different time intervals are as follows Set 1: (months, calls): (1,10),(3,20),(6,30),(9,20),(12,10) Set 2: (1,10),(2,20),(3,30),(4,20),(12,10) I'm pretty sure the average isn't the same in both examples. Can you help??
Thank You !!
Christopher K (2 years ago)
Thank you sir for your lesson on how to add an average line. You made a little tricky piece of logic easy to understand. Thanks.
MrPurpleoj (2 years ago)
yasayaninsan (2 years ago)
Thank you. Very usefull presentation.
Romeo-Alex Ciontos (2 years ago)
Excellent video. Explicit, concise and to the point. Thank you so much. It was of a great help. Like and Subscribe ;)
Vishnu Vakkayil (3 years ago)
Thank you very much
Ashvin Ambegaonker (3 years ago)
You are extremely calm. Superb language to teach. You made a difference to my grade-sheet between Fail and A2.
Eugene O'Loughlin (3 years ago)
+Ashvin Ambegaonker :-) Dr E.
neto garval (3 years ago)
exwhyz33 (4 years ago)
Thank you
Madhav Giri (4 years ago)
Thank you Dr. Eugene for this kind information. Highly appreciate your job !!
Danny Quezada (4 years ago)
Thank you so much.This is very useful.Good job!
Dennis Driscoll (4 years ago)
These are very useful "how to" video presentations.  I am a neophyte excel user and your complete instructions, ie not assuming the viewer knows pre-requisites, has allowed me to learn the tasks in a timely manner. Many thanks!
Naz Hasan Huda (4 years ago)
Thanks for the tips!
Gim me my money (4 years ago)
great video but I was hoping to see here how to draw the average line using only one value 
Mark A Tyson (4 years ago)
Eugene you are an Excel BOSS! Thanks for this video!
xst (3 years ago)
+Ashvin Ambegaonker Rockstar works too, I think
Ashvin Ambegaonker (3 years ago)
+Mark A Tyson Guru might be the word. lol
premiumproductions69 (5 years ago)
Nice video. Thanks. Actually I believe you can right click the chart line, and click "add a trendline" works in 2010 at least. All the best...
Eric Noguchi (5 years ago)
I can't believe there is no straight forward way to do this.
Kevin Smith (5 years ago)
Thanks Eugene ,great help.
Lonewolf0718 (5 years ago)
thanks, it was helpful.
Abolwafa27 (5 years ago)
I knew this information before, but I clicked this video cuz I like your way to explain. Thank You.
Beatrix Rochat (5 years ago)
Thank you, it was very helpful.
Ahmed Ali (5 years ago)
Thanks ... this is very useful. Highly appreciated.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.