excel charts

Creative Infographics in Excel

Infographics in Excel - Creative Chart Ideas How about using the male & female icon instead of a column chart? That would grab people's attention: it would change things up a bit - don't you think? This was a question from one of my

Infographics in Excel: NOT your Usual Bar Chart

In this tutorial you learn how to create a bar chart that includes the male/female icon in a dynamic way. Let's assume you'd like to show the percentage of male/female visitors to your store - and you'd like to show it, like the image

Optimized Excel Line Charts: Prevent Drop to Zero

You'll face two main problems when creating dynamic line charts in Excel: Problem 1: Line series crashes to zero once you attempt to cut-off the series from a certain point. For example you'd like to control the length of the line based on a

Excel Charts: Special Excel Graphs (InfoCharts)

How can you create this chart in Excel? The first time I saw a similar chart was in a report published by Udemy called Learning Trends & predictions in 2017. They used a similar chart to the one below (this one just has sample data

Waterfall Chart in Excel 2016 – Advantages & Limitations

Do you use Waterfall Charts in your Reports? Watch the video to learn how to use the built-in Excel 2016 Waterfall chart. You'll be surprised how easy it is! You'll also see why I still prefer to create it from scratch using other chart combinations.

Excel Charts: Matrix or Excel Panel Charts

When you have too much to tell, don't tell it all in one overcrowded chart. Instead create a panel chart: ONE chart that looks like mini charts placed beside each other. Watch this video to learn how to best visualize many variables in one Excel graph:

Excel Charts: Dynamic Line Series Labels

Default legends are too much work. Not for you, because they are there by default but they can be a lot of work for your readers. They need to think more than they should about which color or texture belongs to which category. Do

Use This Instead of the Pie Chart

Does Your Company Love Pie Charts? So Does Everyone's! The reputation of pie charts has majorly dropped in the past years. For good reason too. Unfortunately, all the coverage by reputable media and books by visualization experts, still haven't persuaded companies to stop using