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

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.

[@pauladriscoll9195]

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!

[@Cashman94]

You are extremely calm. Superb language to teach. You made a difference to my grade-sheet between Fail and A2.

[@EugeneOLoughlin]

Ashvin Ambegaonker :-)
Dr E.

[@puteriafiqah9288]

Thank you.. Your video help me to finish my last minute work😉

[@Abolwafa27]

I knew this information before, but I clicked this video cuz I like your way to explain. Thank You.

[@chrisk5269]

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.

[@newyoume2235]

Wow it's really an awesome explanation

[@sbanik7681]

Simply explained and quiet helpful.... Thanks a lot prof.

[@hectorregala7777]

Thank you. This was very helpful!

[@dannyquezada4387]

Thank you so much.This is very useful.Good job!

[@markatyson9506]

Eugene you are an Excel BOSS! Thanks for this video!

[@Cashman94]

Mark A Tyson Guru might be the word. lol

[@starscollector2009]

Thanks ... this is very useful. Highly appreciated.

[@herrerast]

Terrific! Thank you Eugene. I'm using Excel 2018 in a Mac and worked perfect

[@madhavgiri7642]

Thank you Dr. Eugene for this kind information. Highly appreciate your job !!

[@ericschau2898]

Thank you for the informative video! It was a great help and easy to follow.

[@IAKhan-km4ph]

Thank You Sir. It helps a lot.

[@kevinsmith4076]

Thanks Eugene ,great help.

[@josephsleiman41]

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

[@beatrixrochat7657]

Thank you, it was very helpful.

[@enyiomaoguama882]

Great one to follow. thanks

[@preciousudtohan3604]

8 years ago... but still useful

[@NazHasanHuda]

Thanks for the tips!

[@Lonewolf0718]

thanks, it was helpful.

[@sitiqualijah8053]

very useful info

[@VishnuVakkayil]

Thank you very much

[@iCainiac]

Is that you Roy from the IT Crowd?

[@abuayubanssary3951]

very helpful indeed

[@SannareddyHarshavardhan547]

Thank You !!

[@romeo-alexciontos7800]

Excellent video. Explicit, concise and to the point. Thank you so much. It was of a great help. Like and Subscribe ;)

[@exwhyz33]

Thank you

[@Ericsicons]

I can't believe there is no straight forward way to do this.

[@premiumproductions69]

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

[@jackvrolfe]

Wow! in this one comment everything on the video became silly

[@MrPurpleoj]

Thanks!

[@prefontainesi]

At 50 seconds... I just can't believe Excel doesn't have this function easily accessible!! It's absurd!!

[@netogarcia98]

nice