{"id":1286,"date":"2014-01-18T16:48:58","date_gmt":"2014-01-18T22:48:58","guid":{"rendered":"http:\/\/fortmarinus.com\/blog\/?p=1286"},"modified":"2014-06-28T17:20:06","modified_gmt":"2014-06-28T22:20:06","slug":"waterfall-charts","status":"publish","type":"post","link":"http:\/\/fortmarinus.com\/blog\/1286\/","title":{"rendered":"Waterfall Charts"},"content":{"rendered":"<p>Are you looking for an easy to use, versatile Waterfall Chart template for Microsoft Excel?<\/p>\n<p>The Waterfall Chart, also known as a Bridge, a Walk, flying bricks, or a Mario Chart<sup><a href=\"#footnote_0_1286\" id=\"identifier_0_1286\" class=\"footnote-link footnote-identifier-link\" title=\"Waterfall Chart http:\/\/en.wikipedia.org\/wiki\/Waterfall_chart\" >i<\/a><\/sup>, is a most useful visualization for a variety of applications. It can be used to &#8216;walk&#8217; from a beginning value to an ending value, show the parts of a whole, show changes over time, and more. While Microsoft Excel does not provide a built-in solution for creating this type of chart, Fort Marinus presents a free template.<\/p>\n<p>Please enjoy and comment or email suggestions.<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #9c8a6a;\">_______________________________________________________________________________________<\/span><\/p>\n<p><a name=\"upgradecost\"><\/a><strong><a title=\"Marinus' Waterfall Chart Template for Excel\" href=\"http:\/\/fortmarinus.com\/downloads\/FortMarinus Waterfall Chart Template.xls\" onclick=\"javascript:_gaq.push(['_trackEvent','download','http:\/\/fortmarinus.com\/downloads\/FortMarinus%20Waterfall%20Chart%20Template.xls']);\" target=\"_blank\">Marinus&#8217; Waterfall Chart Template for Excel<\/a><\/strong> (v4.122) 2014 06 26 <span style=\"color: #ff0000;\">NEW!<\/span><\/p>\n<ul>\n<li>No Add-ins, just a good old Excel Worksheet<\/li>\n<li>Ability to show positive and negative changes above AND below zero! (axis crossovers)<\/li>\n<li>Automatic labeling of bar elements<\/li>\n<li>Ability to specify multiple &#8216;Subtotal&#8217; (or &#8216;Anchor&#8217; or &#8216;Middle&#8217;) columns<\/li>\n<li>Ability to toggle &#8216;connector lines&#8217; between bar elements<\/li>\n<li>Convenient formatting shortcuts<\/li>\n<li>Plus, all the usual Excel formatting customizations<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"color: #9c8a6a;\">_______________________________________________________________________________________<\/span><\/p>\n<p><strong>Examples Gallery<\/strong><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" class=\"alignleft size-full wp-image-1156\" title=\"Waterfall Chart Template - Sample Chart\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Sample-Chart.jpg\" alt=\"\" width=\"806\" height=\"313\" \/><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" class=\"alignleft size-full wp-image-1156\" title=\"Waterfall Chart Template - Sample Chart\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Page-Load-Time.jpg\" alt=\"\" width=\"806\" height=\"313\" \/><\/p>\n\n\t\t<style type=\"text\/css\">\n\t\t\t#gallery-1 {\n\t\t\t\tmargin: auto;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-item {\n\t\t\t\tfloat: left;\n\t\t\t\tmargin-top: 10px;\n\t\t\t\ttext-align: center;\n\t\t\t\twidth: 33%;\n\t\t\t}\n\t\t\t#gallery-1 img {\n\t\t\t\tborder: 2px solid #cfcfcf;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-caption {\n\t\t\t\tmargin-left: 0;\n\t\t\t}\n\t\t\t\/* see gallery_shortcode() in wp-includes\/media.php *\/\n\t\t<\/style>\n\t\t<div id='gallery-1' class='gallery galleryid-1286 gallery-columns-3 gallery-size-thumbnail'><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Cash-Flows.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Cash-Flows-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Comprehensive-Income.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Comprehensive-Income-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-EBIT-Gap.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-EBIT-Gap-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl><br style=\"clear: both\" \/><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Headcount.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Headcount-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-PL.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-PL-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Personal-Finance.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Personal-Finance-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl><br style=\"clear: both\" \/><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Store-Growth.jpg\" ><img width=\"150\" height=\"150\" src=\"http:\/\/fortmarinus.com\/blog\/wp-content\/uploads\/2014\/01\/Example-Waterfall-Store-Growth-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" \/><\/a>\n\t\t\t<\/dt><\/dl>\n\t\t\t<br style='clear: both' \/>\n\t\t<\/div>\n\n<p style=\"text-align: center;\"><span style=\"color: #9c8a6a;\">_______________________________________________________________________________________<\/span><\/p>\n<p><strong>Acknowledgements<\/strong><\/p>\n<ul>\n<li>Thanks to Liam Bastick at SumProduct for creating an excellent walkthrough on waterfall charts<sup><a href=\"#footnote_1_1286\" id=\"identifier_1_1286\" class=\"footnote-link footnote-identifier-link\" title=\" Waterfall Charts http:\/\/www.sumproduct.com\/thought\/waterfall-charts\" >ii<\/a><\/sup><\/li>\n<li>Thanks to Aaron Henckler at Chandoo.org for creating an excellent tutorial on waterfall charts<sup><a href=\"#footnote_2_1286\" id=\"identifier_2_1286\" class=\"footnote-link footnote-identifier-link\" title=\" Excel Waterfall Charts http:\/\/chandoo.org\/wp\/2009\/08\/10\/excel-waterfall-charts\/\" >iii<\/a><\/sup><\/li>\n<li>Thanks to Rob Bovey at AppsPro for creating a very useful add-in for labeling charts<sup><a href=\"#footnote_3_1286\" id=\"identifier_3_1286\" class=\"footnote-link footnote-identifier-link\" title=\"The XY Chart Labeler http:\/\/www.appspro.com\/Utilities\/ChartLabeler.htm\" >iv<\/a><\/sup><\/li>\n<\/ul>\n<p style=\"text-align: center;\"><span style=\"color: #9c8a6a;\">_______________________________________________________________________________________<\/span><\/p>\nReferences:<ol class=\"footnotes\"><li id=\"footnote_0_1286\" class=\"footnote\"><a href=\"http:\/\/en.wikipedia.org\/wiki\/Waterfall_chart\" onclick=\"javascript:_gaq.push(['_trackEvent','outbound-article','http:\/\/en.wikipedia.org']);\" target=\"_blank\">Waterfall Chart<\/a> http:\/\/en.wikipedia.org\/wiki\/Waterfall_chart [<a href=\"#identifier_0_1286\" class=\"footnote-link footnote-back-link\">&#8617;<\/a>]<\/li><li id=\"footnote_1_1286\" class=\"footnote\"> <a href=\"http:\/\/www.sumproduct.com\/thought\/waterfall-charts\"  target=\"_blank\">Waterfall Charts<\/a> http:\/\/www.sumproduct.com\/thought\/waterfall-charts [<a href=\"#identifier_1_1286\" class=\"footnote-link footnote-back-link\">&#8617;<\/a>]<\/li><li id=\"footnote_2_1286\" class=\"footnote\"> <a href=\"http:\/\/chandoo.org\/wp\/2009\/08\/10\/excel-waterfall-charts\/\"  target=\"_blank\">Excel Waterfall Charts<\/a> http:\/\/chandoo.org\/wp\/2009\/08\/10\/excel-waterfall-charts\/ [<a href=\"#identifier_2_1286\" class=\"footnote-link footnote-back-link\">&#8617;<\/a>]<\/li><li id=\"footnote_3_1286\" class=\"footnote\"><a href=\"http:\/\/www.appspro.com\/Utilities\/ChartLabeler.htm\"  target=\"_blank\">The XY Chart Labeler<\/a> http:\/\/www.appspro.com\/Utilities\/ChartLabeler.htm [<a href=\"#identifier_3_1286\" class=\"footnote-link footnote-back-link\">&#8617;<\/a>]<\/li><\/ol>","protected":false},"excerpt":{"rendered":"<p>Are you looking for an easy to use, versatile Waterfall Chart template for Microsoft Excel? The Waterfall Chart, also known as a Bridge, a Walk, flying bricks, or a Mario Charti, is a most useful visualization for a variety of applications. It can be used to &#8216;walk&#8217; from a beginning value to an ending value, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,9],"tags":[28,26,31,29,27,30],"_links":{"self":[{"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/posts\/1286"}],"collection":[{"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/comments?post=1286"}],"version-history":[{"count":50,"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/posts\/1286\/revisions"}],"predecessor-version":[{"id":1422,"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/posts\/1286\/revisions\/1422"}],"wp:attachment":[{"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/media?parent=1286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/categories?post=1286"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/fortmarinus.com\/blog\/wp-json\/wp\/v2\/tags?post=1286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}