Тёмный

Five Tips for Optimal Excel Chart Design 

Leila Gharani
Подписаться 2,6 млн
Просмотров 74 тыс.
50% 1

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Here are 5 design tips for creating optimal column charts. The tips are based on a study conducted which uses eye-tracking technology to get insights on how we read and understand charts (see link below).
This is how eye-tacking tests are done: The participant is presented with a question which they need to answer by looking at the visualization on the screen while the camera is tracking their eye movements. Two parameters are measured. One is effectiveness - which means was the answer correct and number two is efficiency, which means how fast were they able to respond.
Attribution: Picture of Edward Tufte By Keegan Peterzell - Own work, CC BY-SA 4.0, commons.wikimedia.org/w/index...
________________________________________________________
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Опубликовано:

 

11 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 231   
@joefromdc
@joefromdc 4 года назад
My tip: Before I publish any report, I ask someone who knows nothing about the information being presented to give feedback. If it takes them longer than five mins to understand anything then I reevaluate my design
@LeilaGharani
@LeilaGharani 4 года назад
That's a great tip!
@ronvds4713
@ronvds4713 4 года назад
Love seeing the results of the eye tracking. Shows that KISS (Keep It Simple Stupid) in charts is the way to go.
@LeilaGharani
@LeilaGharani 4 года назад
It definitely is Ron :)
@Oppadu
@Oppadu 4 года назад
Great Chart lesson ! :) First part with eye tracking is very impressive. But the thing I also would consider when I make chart is Color mathing as well.❤️
@LeilaGharani
@LeilaGharani 4 года назад
Glad you like the video.
@excelisfun
@excelisfun 4 года назад
Great History!!!! Great empirical tests for eye movement. Thanks for the "No Chart Junk" Video, Teammate : )
@LeilaGharani
@LeilaGharani 4 года назад
Thanks Mike. Switching things up a bit :)
4 года назад
So, you are teaching more then excel Leila. Thank you
@LeilaGharani
@LeilaGharani 4 года назад
You're welcome :) Yes switching things up a bit....
@bluesage1528
@bluesage1528 4 года назад
Leila, you are just so perfect in everything that you do! I love all your lessons.
@LeilaGharani
@LeilaGharani 4 года назад
Thank you Victoria!
@karolinagrygiel178
@karolinagrygiel178 4 года назад
Thank you for the tips Leila, I love your way of teaching, it just makes me naturally understand the concepts and techniques, and your online courses are just great, I am grateful
@LeilaGharani
@LeilaGharani 4 года назад
Thank you for the kind feedback Karolina! I really appreciate it.
@dhananjaykansal8097
@dhananjaykansal8097 4 года назад
Oh Yesss....this is lovely! Thank you Mam. I appreciate you're taking care to include a bit of History as well.
@tahirshah6979
@tahirshah6979 4 года назад
If someone want to confuse his boss then work alternatively. If further confusion is required then use secondary axis and remove the labels. If you want to show no differences then don't change origin, otherwise change. Good tips for dealing abusive bosses.
@LeilaGharani
@LeilaGharani 4 года назад
Good tips. Especially using a secondary axis never fails :)
@djfmate
@djfmate 4 года назад
I love this type of analysis which drills down to how people actually read and interpret graphs! Very insightful video Leila! Cheers, David from Australia! 😉👍
@LeilaGharani
@LeilaGharani 4 года назад
Me too, it's really interesting. Greetings to Australia!
@benjaminkeyrose4294
@benjaminkeyrose4294 4 года назад
Values above the bars makes it so much easier! Keep the great tips coming, and thanks for sharing your sources 🙌
@LeilaGharani
@LeilaGharani 4 года назад
I'll do my best :) Glad you like the video Benjamin.
@taco7rk34
@taco7rk34 4 года назад
Getting data is one thing, presenting it effectively is another. I like that you're talking about it more. Thanks for another great video.
@LeilaGharani
@LeilaGharani 4 года назад
Happened to me too all the time. Spent so much time gathering the data and then wasted it all by poor presentation.
@daseaton
@daseaton 4 года назад
This is one of the most powerful, informative, and succinct presentations I have ever seen. Fantastic, as always!
@LeilaGharani
@LeilaGharani 4 года назад
I'm happy to hear that. Glad it's useful for you.
@marcial.1636
@marcial.1636 4 года назад
Just discovered this channel today and love the way she explains things.
@LeilaGharani
@LeilaGharani 4 года назад
Glad to have you here Marcia.
@MrUmbeijo
@MrUmbeijo 4 года назад
Thank you so much Leila for your videos. I have improved a lot of my reports for the management thanks to your Excel tips. I will implement these 5 design tips in my reports to make them even more efficient and effective.
@LeilaGharani
@LeilaGharani 4 года назад
I'm very happy to hear that.
@kaaa3485
@kaaa3485 4 года назад
Great Tips Leila. I'm always learning from your videos. You are greatly appreciate it. Thanks.
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome. Makes me happy when the tutorials are helpful.
@stefanzonneveld317
@stefanzonneveld317 4 года назад
Some great tips! Like always. Thanks Leila. What I did missed and maybe was worth mentioning is a target value, this way anyone that see the chart can understand that the results are low or high.
@DK-ls1tx
@DK-ls1tx 4 года назад
Love u so much Leila for helping us on Excel 😘😘
@dennisd5776
@dennisd5776 4 года назад
WOW, I never realized the eye movement in reading a graft. Thank you for this useful information.
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome Dennis. Glad it's useful.
@vevekharaswal7825
@vevekharaswal7825 4 года назад
WoW that's super interesting for our kind researchers documentation thanks for sharing Leila 🙏😍feels blessed👍
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure. Glad you like it.
@petermoran6800
@petermoran6800 4 года назад
Thank you, once again you excel in these videos and are forever improving my spreadsheets
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure Peter. I'm happy if the tutorials are helpful.
@asetbilibaev6519
@asetbilibaev6519 4 года назад
I love your channel. It’s very helpful.
@georgetosounidis5545
@georgetosounidis5545 4 года назад
You thanked us for watching, we thank you for existing! (and providing us with all this) Thanks a lot for this, i can only imagine the number of UX pilot tests this took...
@shahinshakarli5329
@shahinshakarli5329 4 года назад
Thank you, Leila! These tips are crucial.
@LeilaGharani
@LeilaGharani 4 года назад
Glad it was helpful!
@landonchurch1
@landonchurch1 4 года назад
I find that the study referenced changes these tips from optional, personal preferences to proven techniques. I love the eye tracking charts! Thank you!
@LeilaGharani
@LeilaGharani 4 года назад
Yeah, for me it was an eye-opener too.
@haythamelmaghawry2845
@haythamelmaghawry2845 4 года назад
Well done Leila Super, simple and cover most important requirements on Charts
@LeilaGharani
@LeilaGharani 4 года назад
Glad you like the video.
@monte4955
@monte4955 4 года назад
Awesome as always Leila.👍
@subhrajyotisaha4u
@subhrajyotisaha4u 4 года назад
Super. Loved the video and detailed analysis.
@francescox79
@francescox79 4 года назад
Compliments to you Leila and your Team, you are awesome!
@LeilaGharani
@LeilaGharani 4 года назад
Thank you Francesco
@maciejolejnik6706
@maciejolejnik6706 4 года назад
Thank You Leila for basic and very useful informations!
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure Maciej. Glad the video is useful.
@yulinliu850
@yulinliu850 4 года назад
Great teaching! Thanks Leila!
@krn14242
@krn14242 4 года назад
Thanks Leila, great explanation. I had not thought about this before.
@LeilaGharani
@LeilaGharani 4 года назад
Glad you like it.
@MohamedMostafa-dm9qy
@MohamedMostafa-dm9qy 4 года назад
Very helpful as usual
@luvlegendas
@luvlegendas 4 года назад
Obviously that was the most beneficial and helpful information in a video I have seen so far in 2019, or may be my entire life. As a data analyst in my department I am always seeking the best practice in data visualization in my report to help reader locate info easily and never get lost. thank you for this valuable video.
@LeilaGharani
@LeilaGharani 4 года назад
Thank you for the kind feedback Ahmed! I'm glad the video is helpful for you.
@christophenael3284
@christophenael3284 4 года назад
Thank you Leila! For rule number 3, it is very important not to write numbers with a font size too small indeed but rather than write vertically, I prefer to format my numbers in thousands for example and always write them horizontally because it is our normal reading direction.
@LeilaGharani
@LeilaGharani 4 года назад
That works too Christophe. Thanks for the feedback.
@Oprimaita
@Oprimaita 4 года назад
This kind of video is very useful and efficient. Thank you again and again
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure. I'm glad you like the video.
@ashrafabdalghani77
@ashrafabdalghani77 4 года назад
Thank You so much The Teaching Method Is Excellent We Wait For Moe
@LeilaGharani
@LeilaGharani 4 года назад
There will definitely be more. Stay tuned :)
@vijayarjunwadkar
@vijayarjunwadkar 4 года назад
Wow! another great video! Never imagined so much could be involved behind a chart and its understanding! Thanks for these super tips! :-)
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure. Glad you like my little detour to research :)
@pmsocho
@pmsocho 4 года назад
Great tips!
@simfinso858
@simfinso858 4 года назад
So detailed video on charts.Useful video
@darrylmorgan
@darrylmorgan 4 года назад
Very interesting Leila.Definitely something to think about.Thank You
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome Darryl.
@adedejioluwapelumi849
@adedejioluwapelumi849 4 года назад
Thanks so much for this informative piece Leila.
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome. Glad you find it informative.
@lemd49
@lemd49 4 года назад
As usual, very actionable advice.
@maxpower111
@maxpower111 3 года назад
Thank You Leila, great analysis.
@LeilaGharani
@LeilaGharani 3 года назад
Glad you enjoyed it!
@stevennye5075
@stevennye5075 4 года назад
excellent information, I liked the vertical numbers in tip 3
@ExcelWithChris
@ExcelWithChris 4 года назад
Thanks. Very helpful.
@peterjohnsarador6194
@peterjohnsarador6194 4 года назад
Thank you so much Leila for this information.. 👍😊
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome Peter :)
@funniq
@funniq 4 года назад
Thanks again for sharing your knowledge. Very sweet of you. To make such high quality tutorials is very time consuming .... Hugs from Holland
@LeilaGharani
@LeilaGharani 4 года назад
Thanks for the appreciation André!
@katerina6495
@katerina6495 4 года назад
Vielen Dank Liebe Leila 🤗 I always love your charting techniques Viele liebe Grüsse
@LeilaGharani
@LeilaGharani 4 года назад
Always makes me happy to see your comments popping up :)
@goodgollywally
@goodgollywally 4 года назад
Another great video. I use bar charts and trend charts. I can see the difference more easily between current year and SPLY with trend charts, but that's just the way it works best for me. All great information in this video. I like making the title standout in font size. Thanks Leila.
@LeilaGharani
@LeilaGharani 4 года назад
Thanks for the feedback Walter!
@guyngansop2982
@guyngansop2982 4 года назад
Always great and awesome😉
@ManthaarJanyaro
@ManthaarJanyaro 4 года назад
Enjoyed learning...
@karunkumar6577
@karunkumar6577 4 года назад
Great video..thanks !
@jimmyjammERz559
@jimmyjammERz559 4 года назад
I love your Excel tips!
@SeamusHarper1234
@SeamusHarper1234 3 года назад
Axis braking: This is an excelent example for the influence the chart designer has on the viewer. You want to tell the story that nothing changed? Don't break the axis. You want to make them belive that there was a radical change / high volatility? Beak it ;-)
@davidneil9110
@davidneil9110 4 года назад
Amazing!
@npoess
@npoess 4 года назад
Great Stuff!
@yurd563
@yurd563 4 года назад
Thanks for video!
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome.
@wayneedmondson1065
@wayneedmondson1065 4 года назад
Hi Leila.. eye tracking.. that's cool. It's amazing how much chart junk is out there.. and from sources that should know better. Your 5 points are great and thanks to your various videos and courses.. are all familiar and in my tool bag. Thanks for sharing your amazing knowledge, skills and insights. Thumbs up!!
@LeilaGharani
@LeilaGharani 4 года назад
Thanks for the thumbs up Wayne!
@mehdihammadi6145
@mehdihammadi6145 4 года назад
Thank you for sharing Leila, very informative and I'm using 4 of the tips, the last one is new for me (size of the title) but I will consider that in the future
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure Mehdi. It's helpful for the viewer to see right away what the chart is about.
@ajexcel
@ajexcel 4 года назад
Yes that's indeed helpful tips! Thanks
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure. Glad it's helpful.
@hattemghanoom9557
@hattemghanoom9557 4 года назад
Thank you Leila Very helpful presentation tips
@LeilaGharani
@LeilaGharani 4 года назад
You're welcome 😊
@sytzebuz
@sytzebuz 4 года назад
...and as always, Thanks Leila!
@LeilaGharani
@LeilaGharani 4 года назад
... and as always, you're very welcome :)
@OakleyTurvey
@OakleyTurvey 4 года назад
Thanks once again Leila, Nice to have study data to back up what we have been trying to impress on people for years. Especially like the NO 3D...nearly 50% slower comprehension. Probably even more for 3D Pie Charts. Be great if your Uni sends the results of the study to Microsoft for their Excel and Power BI development teams...
@LeilaGharani
@LeilaGharani 4 года назад
Yeah, it was really interesting to see these results in an objective research.
@hernanperez912
@hernanperez912 4 года назад
My thumbs up today is for you! 👍... And yes, it was helpful.
@LeilaGharani
@LeilaGharani 4 года назад
Then the video did its job :) Thanks for the thumbs up Hernan.
@Molnify
@Molnify 4 года назад
Great video!
@mohmmadabdo5899
@mohmmadabdo5899 4 года назад
Thanks for your advices 💋 I need those for my job 📊
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure. I'm glad if the videos are helpful.
@jayshukla450
@jayshukla450 4 года назад
Thank you Soo much
@DougHExcel
@DougHExcel 4 года назад
great data viz concepts!
@KnuYorker
@KnuYorker 4 года назад
Excellent video. The only bad thing about it is that it exposes the many mistakes I have been making over the years. I'm sure I'll review this video a few more times before building charts. Thanks!
@LeilaGharani
@LeilaGharani 4 года назад
Haha, I've made all of these and many more too. But, the good thing is we can learn and improve :)
@Buhassan5656
@Buhassan5656 4 года назад
Wonderful...wonderful....wonderful keep going.....
@LeilaGharani
@LeilaGharani 4 года назад
Glad you like the tutorial Ahmed. There will be more. Stay tuned :)
@luisneto2165
@luisneto2165 4 года назад
Wow! Nice tips for my students!
@LeilaGharani
@LeilaGharani 4 года назад
Hope it will come in handy Luís.
@YTNutflexPayb
@YTNutflexPayb 9 месяцев назад
More of this please 🙏
@excelaficionado
@excelaficionado 4 года назад
That's creative and informative.....👌👌👌👌👌
@LeilaGharani
@LeilaGharani 4 года назад
Glad you like it!
@matioesperante7518
@matioesperante7518 Год назад
Hi Liela Thank you so much for your videos - you were the first person I started watching on youtube to do with excel and I've not stopped yet :) Anyway this is just an idea please - I wasn't taught about variance at at school and wondered if you could create an video please about how to build a table and/or graph which best covers this for multiple area. At work I various processes running on many PCs and I would like to create a variance graph that shows variances to do with how showing which PCs take the longest to run the different processes. That way I can inform the customer for those PCs to be checked out for example to perform PC health checks on them. Anyway I hope you find this challenge interesting and can cover this please for us IT Support people :)
@vigneshasokan5586
@vigneshasokan5586 4 года назад
Excellent
@vikrapareek
@vikrapareek 4 года назад
Refreshing.
@alexgabriel37
@alexgabriel37 4 года назад
Great info overall. If I may offer some feedback, your #4 tip is very vague, uses unusual wording (don’t break the axis?), and the 5 second comparison doesn’t highlight the difference. I think the takeaway is to scale the axis with the data to ensure the graph visually highlights the information and pertinent trends. Ie, doesn’t always have to start with 0.
@LeilaGharani
@LeilaGharani 4 года назад
Thanks for the feedback!
@huytangquoc5682
@huytangquoc5682 4 года назад
Its great to help me figure what the #4 tip means !! thanks for both of you ^^
@reeseinny
@reeseinny 4 года назад
I would like a video on using the proper scale for an axis which is what I think you meant from point #4.
@shabbirkanchwala-abwaab6263
@shabbirkanchwala-abwaab6263 4 года назад
Good Thnx Tip # 3 is more practical n easy to analyze
@LeilaGharani
@LeilaGharani 4 года назад
You're very welcome :)
@betoalema
@betoalema 4 года назад
Nice!
@yoggangurde
@yoggangurde 4 года назад
Impressive I have never use any of the tricks. This was real useful👍
@LeilaGharani
@LeilaGharani 4 года назад
I'm glad to hear that.
@yoggangurde
@yoggangurde 4 года назад
@@LeilaGharani 😊👍
@waelhussein4606
@waelhussein4606 4 года назад
Love your videos as usual. Nevertheless, I noticed you spent a lot of time on the eye tracking issue and then cut down on the main points, particularly towards the end. Thank you though so much, as I find your videos to always be useful.
@vivekphadke16
@vivekphadke16 4 года назад
As usual crisp, informative and comprehensive. History of graphs was the icing on the cake.
@LeilaGharani
@LeilaGharani 4 года назад
Glad you liked our little trip back in time :)
@Betterifitsfree
@Betterifitsfree 4 года назад
I wish there was a mandatory law to make those who create the awful presentations charts to watch this and learn the correct way it should be done. Thank you Leila.
@LeilaGharani
@LeilaGharani 4 года назад
Yeah, that would be good :)
@robg109
@robg109 4 года назад
Great vid. Maybe deserves more time on this subject
@LeilaGharani
@LeilaGharani 4 года назад
True, maybe I'll expand in a follow-up video. Thanks for the feedback!
@derekfingleson3749
@derekfingleson3749 4 года назад
You so cool... Mad for you !
@joefromdc
@joefromdc 4 года назад
Thanks for the tips, I’ve taken Edward class in California.
@LeilaGharani
@LeilaGharani 4 года назад
That must have been amazing!
@joefromdc
@joefromdc 4 года назад
Leila Gharani It was cool, he gives out four other books besides the one you displayed in the video
4 года назад
I am a Tufte fan / follower!
@casper3842
@casper3842 4 года назад
getting prettier than ever! :)
@casper3842
@casper3842 4 года назад
May i send email to solve my issue?
@ExcelExciting
@ExcelExciting 4 года назад
Great trip.. thanks for sharing.. I never use 3D chart
@LeilaGharani
@LeilaGharani 4 года назад
Neither do I :)
@hosseinhosseinpoor4845
@hosseinhosseinpoor4845 3 года назад
thanks...
@shaheershujaat2223
@shaheershujaat2223 4 года назад
Wow Leila you look very nice and beautiful amazing video well done 😊😊❤️❤️👍👍
@joshuamanampiu6489
@joshuamanampiu6489 4 года назад
Very helpful. I normally truncate the numbers of they are too big (present in thousands or millions) instead of presenting them vertically I find it a bit odd reading numbers that way but it is an interesting tip.
@LeilaGharani
@LeilaGharani 4 года назад
That works too Joshua. Thanks for the feedback!
@BernieTheBoxer
@BernieTheBoxer 4 года назад
Fascinating stuff. Trying to get my skill levels up in Power BI and some of the visualisations being bandied around the analytics world these days are just beyond baffling. I think all the analytics package providers would do well to subject their "fancy" outputs to your study - I bet I could guess the results?
@LeilaGharani
@LeilaGharani 4 года назад
Me too Chris :)
@toddclark7709
@toddclark7709 4 года назад
Leila - thanks for the video - very interesting! Regarding tip #4, I may be misunderstanding your recommendation, but I generally do start a bar graph with 0 on the y axis, otherwise it can be misleading about the relative difference between the bars. Just my 2 cents!
@LeilaGharani
@LeilaGharani 4 года назад
Absolutely true Tood! Especially for bar charts breaking the axis (not starting at zero) will mislead the reader.
@quasipseudo1
@quasipseudo1 4 года назад
I own that book - a great reference.
@LeilaGharani
@LeilaGharani 4 года назад
It's a classic.
@mwendasilumesii9649
@mwendasilumesii9649 4 года назад
Hello Leila, great stuff as usual. On DONT BREAK THE AXIS, kindly expand. Are we you start from ZERO or another figure that then allows for a higher degree of accuracy if one had to guess the values (supposing they are no data labels).
@SayedZaade
@SayedZaade 4 года назад
Deep impact..
@SteveSwanson999
@SteveSwanson999 4 года назад
Appreciate the effort and supporting data. Thank you. Was looking to delve more into the details, but a good deal of the reference material above is in German - are English versions available? Stay safe, Steve
@LeilaGharani
@LeilaGharani 4 года назад
You need to scroll down more. The top part is German but further down they have the English material.
@aliibrahem6313
@aliibrahem6313 4 года назад
Great info as usual. I loved the idea of measuring the eye movement; it's so scientific. In general, 2D is better than 3D; but the 3D here wasn't of a great design.
@LeilaGharani
@LeilaGharani 4 года назад
I loved the approach too. I'm not a big fan of 3D anyway so at least now I have research to back it up :)
@hansamfotos
@hansamfotos 4 года назад
Color also plays a vital role on reporting. Especially when you are reporting fixed and moving figures.
@LeilaGharani
@LeilaGharani 4 года назад
Very true. Color is important.
Далее
10x your productivity with these AI tools in Excel 😲
18:42
Excel Mini Charts - BETTER than Sparklines!
10:34
Просмотров 185 тыс.
Make Impressive McKinsey Visuals in Excel!
16:47
Просмотров 273 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн