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
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
Dynamic column and bar charts are great for showing variances. Dynamic arrows also work great here! How can you create this in Excel? In this full series you will find four ways to visualize variances. Method A: Uses a column chart with dynamic coloring
Watch the video to learn how to create a Waterfall or Bridge Chart in Excel. From Scratch! It uses simple but unusual techniques to quickly and easily get a Waterfall Chart that also works with negative cumulative values. If you prefer to read instead of watching,
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.
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: