Here, Green Bars is for the total column, Blue Bars are for positive values and Red Bars are for negative values. This is how an Excel 2016 Waterfall Chart looks like:Īs you can see the columns are color-coded to distinguish between total, positive and negative values. The first and last column represents total starting and ending values whereas the intermediate columns represents a series of changes from one period to another. They are very useful in that they show how the initial value is affected by a series of positive and negative expenses through a series of changes.
Waterfall Chart is an advanced type of Column Chart. Let’s look into each of these points one-by-one!
DOWNLOAD OUR FREE 101 BEST EXCEL TIPS & TRICKS E-BOOK!
0 kommentar(er)
