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.