Waterfall chart is a very good choice for displaying cumulative effect of a series of positive and negative values. You will learn to create it in a couple of second with this article.
Waterfall chart is a standard chart coming within Excel 2016. You can create this chart on previous releases but you need to but a lot of work to create a decent waterfall chart. You can read about it here:
How to create a waterfall chart with older versions of Excel.
Creating a waterfall chart with Excel 2016 needs only a ccouple of steps:
1.Prepare your data set:2. Select your data and insert a Waterfall Chart:
(Excel will also recommend this chart to you if you check “Recommended Charts” in INSERT ribbon.)
3. Double-click on the last column and click on “Show connector lines” and Set as total” options.
4.Format your chart:Formatting part needs a little bit of experience with Excel. But I strongly recommend you to work on this to develop a better understanding of chart elements and chart formatting.
If you would like to see how fancy formatting is done, you can continue to the next page.
That’s an expert answer to an inetnestirg question