Creative Infographics in Excel

Creative infographics in Excel (Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this: Set up the data table Insert a clustered column

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