How to add a LINE to your charts in Excel - Super easy trick

How to add a LINE to your charts in Excel - Super easy trick

Chandoo

2 года назад

65,052 Просмотров

This one is a massively simple yet amazingly useful. Use a calculated column to add average/maximum/target lines to your charts.

Download the sample file from here 📈👇
=================================
https://chandoo.org/wp/wp-content/uploads/2022/02/average-line-on-charts.xlsx

WANT MORE CHARTS? See these videos next 📈📊👇
============================================
The easiest dashboard trick ever - link two charts - https://youtu.be/26Hhheh4OnE
Highlight top 5 items in a chart - https://youtu.be/Gx9ZVlGkbOk
Lollipop Chart 🍭🍭🍭 - https://youtu.be/pRZ2JzvRVlA

🎵 More charts (playlist) - https://www.youtube.com/watch?v=vK_PsW-RE-g&list=PLmejDGrsgFyBi4uTM0yTHZdw97cgg5Vnq

~
Have an "above average" day 😀

#ExcelCharts

Тэги:

#chandoo #chandoo.org #Excel #spreadsheets #how_to_insert_target_line_in_excel_graph #how_to_add_a_target_line_in_an_excel_graph #how_to_add_target_line_in_excel_graph #how_to_add_a_target_line_in_excel_graph #how_to_put_target_line_in_excel_graph #how_to_add_average_line_to_excel_chart #how_to_add_average_line_in_excel #how_to_add_average_trendline_in_excel
Ссылки и html тэги не поддерживаются


Комментарии:

Chandoo
Chandoo - 12.02.2022 00:32

Hello AWESOME Person... 👋👋👋
What other charting tips / ideas you want to see? Reply with your comments.

Ответить
Indigenousim
Indigenousim - 17.04.2023 01:23

That helped, thankyou sir

Ответить
DR. KESAV SARMA MAGANTI
DR. KESAV SARMA MAGANTI - 07.01.2023 11:05

Need suggestions, strategies to increase sales that are below average line & also a seperate video on how to present data visualization in a meeting i.e, story telling...in detailed. Thank you

Ответить
Harish Prasad
Harish Prasad - 27.10.2022 13:39

Superb sir 👍

Ответить
code dsfr
code dsfr - 24.10.2022 20:59

Hi thank you for the all updates. I have multiple sheet with multiple info how can I change to one sheet

Ответить
Shyam Pratap Rathore
Shyam Pratap Rathore - 08.10.2022 22:18

You are awesome

Ответить
Food & Finance
Food & Finance "F&F" - 06.10.2022 05:58

Wow. Great and easiest way... I'm day by day learn from your end lot of Excel short cut.... thanks master...keep posting your video

Ответить
sf~
sf~ - 29.08.2022 22:01

After your Beginner to Pro Excel Data Course, this playlist is next on my list. I've learnt so much from that one video. Here's to learning more from you.

Ответить
Mohamed Hafez
Mohamed Hafez - 23.08.2022 23:25

easy tut. thanks from egypt

Ответить
Deepali
Deepali - 07.05.2022 13:39

hey , if i have 4 columns naming rev from product A,B,C,D respectively and 5th column which is parent id. now i want to find the average total rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products) .
what formula i should use?

Ответить
cherif cherif
cherif cherif - 22.04.2022 21:17

Hi ,how to send emails from excel choosing email from.
In fact il have two accounts in outlook , personal one and groupe one and I want to choose the group one to send emails,.
Thank you for your feedback.

Ответить
David Ferrick
David Ferrick - 29.03.2022 22:00

Same approach for a Goal (Percent of Improvement) line.

Ответить
CA Nirmal Choudhary
CA Nirmal Choudhary - 20.02.2022 17:50

Nice tip

Ответить
Prashant Kishor Kumar Soni
Prashant Kishor Kumar Soni - 14.02.2022 18:55

SIR, why your channel is UNDERRATED.

Ответить
Aditi Jain
Aditi Jain - 12.02.2022 18:25

I'm not able to convert column into line with microsoft excel 2010.

Ответить
VISHWAJEET GHORPADE
VISHWAJEET GHORPADE - 11.02.2022 18:48

Hi Chandoo. I subscribed to your channel today. Can you please make a video on "How to get clients for freelancing with excel" ?

Ответить
alka gupta
alka gupta - 11.02.2022 16:41

Sir, How to use "EDATE" {EDATE(start_date, -1)} functionality in "Power Query in Excel"
Means to calculate the previous date where, month is previous month but date is same
e.g.
I/p is 2 dec 2012 ==> O/p is 2 Oct 2012
I/p is 9 Jan 2011 ==> O/p is 9 Dec 2010
I/p is 4 apr 2013 ==> O/p is 4 May 2013

Ответить
DataGeek Academy
DataGeek Academy - 10.02.2022 21:24

Been reading your tips and tricks through your blogs way back before. Good transition to YT though. Will keep on watching different tips every day. After all, Excel is the foundation and our best friend ;) Thanks for sharing chandoo.

Ответить
Suraj Bhardwaj
Suraj Bhardwaj - 10.02.2022 19:08

Wow... Nice One... 😀 Converting column to line never thought ....This one best. Thank you👍

Ответить
Wayne Edmondson
Wayne Edmondson - 10.02.2022 02:28

Great one Chandoo! Thanks for sharing how to add an average line with data label to an existing column chart. Very useful! Thumbs up!!

Ответить
Aman Malalo
Aman Malalo - 09.02.2022 21:16

Simple and clear. Thanks very much

Ответить
signofshine jobs
signofshine jobs - 09.02.2022 20:09

You are always awesome👍👍

Ответить
Suhas A Shetty
Suhas A Shetty - 09.02.2022 17:20

Thank you!!

Ответить
Gurdeep Jassal
Gurdeep Jassal - 09.02.2022 16:12

Simple and straightforward. Thanks for sharing Chandoo. 👍

Ответить
Asif Raja
Asif Raja - 09.02.2022 13:26

Is there any platform on which we can ask questions? Please share

Ответить
lakshmi devi collections
lakshmi devi collections - 09.02.2022 12:52

Best excel guru

Ответить
Chris M
Chris M - 09.02.2022 12:50

Thanks Chandoo!

Ответить
Arvind Kumar
Arvind Kumar - 09.02.2022 12:23

sir how to normalised data ?

Data like :
345
567
987
4566
99
5436
777
How to this data normalised in range between -100 to 100 ??? Please help
🙏🙏🙏

Ответить
Hyper Gaming
Hyper Gaming - 09.02.2022 11:45

Thank you for the useful information

Ответить
Ahmed Tareq
Ahmed Tareq - 09.02.2022 11:44

This is great tricks, thank you

Ответить
Emre Murat
Emre Murat - 09.02.2022 11:35

Hello Chandoo,

Is there a calculation method that calculates the areas of the data under the line in excel?

Ответить
kuuuyajim
kuuuyajim - 09.02.2022 11:09

Useful tip for setting target line(s) as well. 😃 Thanks for sharing this, I almost forgot the copy+paste trick. 😅

Ответить
Kannan P
Kannan P - 09.02.2022 11:07

Thank you ❤️

Ответить