excel charts

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

Excel: Better Variance Charts – Dynamic Columns, Lines & Arrows

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

Easiest Waterfall Chart in Excel From Scratch (works with negative cumulative values)

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,

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