How Do You Build A Waterfall Graph?
Waterfall charts represent a set of data that impacts a single derived number. It’s a visual aid to show how numbers relate to each other. That’s according to Databison, who state that a good example of a waterfall chart is a profit and loss statement, because profit impacts each number in the chart.You should be familiar with entering data and formulas into Excel spreadsheets for this example, which shows how to build a basic waterfall graph with sales data. Fill the following cells in an Excel worksheet with the data in parentheses. Peltier Technical Solutions note that cell A2 should contain a space. All other cells are blank: A2 ( ) A3 (Initial) A4 (Internet) A5 (Markets) A6 (Website) A7 (Bookstores) A8 (Misc.) A9 (Subscriptions) A10 (Direct Mail) B1 (Invisible) B4 (2,000) B5 (3,000) B6 (19,000) B7 (2,100) C1 (Final) C9 (8,500) D1 (Minus) D5 (1,000) D6 (2,000) D7 (3,000) E1 (Plus) E4 (2,000) E8 (2,500) F1 (Initial) F3 (10,000) Insert the following formula into B4: =SUM(B3,E3:F3)-D4
