![]() Stay in this view and change the chart type of Before and After series to a Line. Select either the Before or After series, right-mouse click and Change series chart type…. As smart as Excel is, you need to be consistent with your ranges, otherwise it will assign the wrong value to your Deltas.Īt this point, your Waterfall looks like this – no worries, we’re just a few clicks away. The headers help Excel identify that you’re adding new series and by highlighting the empty cells below the deltas you remain consistent with your categories. Notice you’re including the headers and the empty cells below the deltas. Select A7 to A14, hold down the control key and highlight D7 to F14. Now that we’ve set up the data, let’s start with our Waterfall. Plus we’ll need it later for our connectors.Ĭumulative series is =SUM($B$8:B8) → written in C8 and pulled down till C13.īefore series =C8 → written in E9 and pulled down to E13 (covers all the deltas)Īfter series = C9 → written in F9 and pulled down to F13 (covering all the deltas) It’s good to know and it can simplify some of our other formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |