3 Tips for Impressive Excel Charts

Elevate your Excel chart-making skills with this, which focuses on creating effective and easy-to-understand charts. Ideal for anyone who works with Microsoft Excel data, this tutorial offers valuable insights into chart design.

Here's what you'll learn:

Principle of Simplicity: Understand the importance of keeping your charts simple by removing unnecessary elements. Learn why it's vital to use simple fonts, avoid 3D charts, and stick to basic, clear visuals.

Clarity in Charts: Explore the concept of the data-ink ratio introduced by Edward Tufte. Discover techniques to highlight crucial data by reducing unnecessary visual elements and focusing the viewer's attention on what matters.

Effective Chart Titles: Find out why every chart should have a clear title, ideally positioned for easy reading.

Truthful Data Representation: Learn the best practices for displaying data honestly, including consistent scaling and avoiding axis breaks that might mislead the viewer.

Series Labels and Legends: Get tips on how to effectively use legends and data series labels, especially in line graphs, to make your chart more understandable.

Highlighting Key Data: Understand how to emphasize the most important parts of your data to quickly convey your message.

Consistency in Color and Style: Discover the importance of using consistent colors and styles throughout your reports to maintain a professional look and enhance readability.

🚩Let’s connect on social:

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

[LeilaGharani]

If you've liked our older Excel chart videos, you'll love the advanced methods in this course. You’ll improve your Excel skills and make your processes faster.

[chinpingshoon]

Leila.... been learning your channel few year back then. Wow... you been improving your look quitr dramatically. tq. lovely

[valerianverdy]

you never stop to amaze me.. another one goes into my list.. Thank you, you made my life easier

[oompalumpus]

Seeing younger Leila vs current Leila, you can tell the difference between their skill levels.

That, and younger Leila's crunchier mic 😁

[MohamedMostafa-dmqy]

That is really helpful Leila, I am wondering if you can advise how did you make this chart showed up in min 3:40, how did you make the budget turn over chart to be just line I am confused 😃😃

[mohamedabdelaziz]

Hi Leila, Thank you very much for your helpful videos, your explanation is awesome as well as your videos content.

[lisaamante]

Las Vegas, NV, USA: Question. At timestamp 3:13 you show an image of the legend placed on the series in the line chart with 2 series. How do you do that? I've searched in the internet for hours today and can't figure it out. Every time I try, it puts the series name on every single data point. These tips are awesome, thank you!!

[jubeetharakan]

Hi Leila,
Is there away to add pop up messages on the graph itself? For example if I click on one bar on the bar chart it pops up details about that specific bar.

[kutra]

Great Video(s) Leila! Learning a lot from you! Btw does your course on udemy cover further advanced topics vs. your youtube videos? If so, could you elaborate what would be the additional content? I ask as your youtube videos are very comprehensive and pretty advanced in themselves:)

[Tharindu]

Hi..
Your explanation excellent.. could u pls assist on map chart as my excel 2019 not showing any map.do i need to download map first ? I want pacific countries map ??

[doperich]

how to arrange x axis randomly..like produc1 than prduct5..prodct..3..2..6 likewise

[DrRonontheInternet]

"simple... clear... consistent"