{"id":3072,"date":"2020-07-23T00:38:45","date_gmt":"2020-07-22T22:38:45","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3072"},"modified":"2024-04-30T19:28:47","modified_gmt":"2024-04-30T17:28:47","slug":"create-waterfall-chart-excel-2016","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-waterfall-chart-excel-2016\/","title":{"rendered":"Create an Excel 2016 Waterfall Chart"},"content":{"rendered":"<p>Waterfall Charts are <strong>one of the many new Charts<\/strong> available only in Excel 2016.<\/p>\n<p>When I was working at General Electric, I had to create Excel 2016 Waterfall Charts on a monthly basis using <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a>&#8230;.ouch!<\/p>\n<p>They are very popular in the current corporate environment as they graphically<strong> show the positive and negative movements<\/strong> within your Monthly Net Profit or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cash-flow-to-stockholders-formula\/\" target=\"_blank\" rel=\"noopener\">Cash Flow<\/a>.<\/p>\n<p>In this article, we will discuss the following concepts regarding an Excel 2016 Waterfall Chart:<\/p>\n<ul>\n<li><a href=\"#what-is-a-waterfall-chart\"><strong>What is a Waterfall Chart?<\/strong><\/a><\/li>\n<li><strong><a href=\"#when-to-use-waterfall-chart\">When to Use Waterfall Chart?<\/a><\/strong><\/li>\n<li><a href=\"#how-to-create-an-excel-2016-waterfall-chart\"><strong>How to Create an Excel 2016 Waterfall Chart?<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look into each of these points one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"what-is-a-waterfall-chart\"><\/a>What is a Waterfall Chart?<\/strong><\/h3>\n<p>Waterfall Chart is <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-column-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">an<\/a> advanced type of Column Chart.<\/p>\n<p>They are very useful in that they<strong> show how the initial value is affected by a series of positive and negative expenses\u00a0<\/strong>through a series of changes.<\/p>\n<p>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.<\/p>\n<p>This is how an Excel 2016 Waterfall Chart looks like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone wp-image-3080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"765\" height=\"398\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall.png 765w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall-300x156.png 300w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><\/a><\/p>\n<p>As you can see the columns are <strong>color-coded<\/strong> to distinguish between total, positive and negative values.<\/p>\n<p>Here,<strong> Green Bars<\/strong> is for the total column, <strong>Blue Bars<\/strong> are for positive values and <strong>Red Bars<\/strong> are for negative values.<\/p>\n<p>They are also called <strong>Excel Bridge Chart<\/strong> and they show how the intermediate columns connect the start and end columns.<\/p>\n<h3><strong><a id=\"when-to-use-waterfall-chart\"><\/a>When to Use Waterfall Chart?<\/strong><\/h3>\n<p>The main purpose of creating Excel 2016 Waterfall Chart is to<strong> show the change in value from the starting point to the final result<\/strong>.<\/p>\n<p>They are mainly <strong>used in business applications<\/strong> but can be used to illustrate any process with additions and subtractions based on a starting value.<\/p>\n<p>It can be used to evaluate the following :<\/p>\n<ul>\n<li>Change in company&#8217;s profit<\/li>\n<li>Change in inventory levels<\/li>\n<li><span data-story-id=\"story_b58bab7b0f5203e2f71a0449cd4f1f06\" data-room-id=\"room_d62db1d106bc54e2ee4e1d1ed91d580e\" data-timestamp=\"1595821249632\" data-text=\"Change in product\u2019s earnings\" data-userid=\"1245285956862005248\" data-orgid=\"425304450073260032\">Change in product\u2019s earnings<\/span><\/li>\n<li>Budget change in a project<\/li>\n<li>Tracking demographic changes<\/li>\n<li>Change in cash flow<\/li>\n<\/ul>\n<p>Let&#8217;s take a look at how to create a Waterfall <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pie-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">chart in Excel<\/a> 2016.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"how-to-create-an-excel-2016-waterfall-chart\"><\/a>How to Create an Excel 2016 Waterfall Chart?<\/strong><\/h3>\n<p>In this example, I show you how easy it is to<strong> insert a Waterfall Chart<\/strong> using Excel 2016.<\/p>\n<p><em>NB: If you do not have Excel 2016 installed, there are a couple of great Excel add-ins that allow you to insert these charts in Excel 2013 and prior:<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/waterfalladdin\" target=\"_blank\" rel=\"noopener noreferrer\">The Waterfall Chart Creator<\/a>\u00a0by TheSpreadsheetGuru<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/peltierchartaddin\" target=\"_blank\" rel=\"noopener noreferrer\">Peltier Tech Charts for Excel<\/a>\u00a0by Jon Peltier<\/p>\n<p><strong><em>Want to know how to create a Waterfall Chart?<\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>Example 1:<\/strong><\/span><\/p>\n<p>Watch it on <strong><a href=\"https:\/\/youtu.be\/FUeqA9MAPZo\" target=\"_blank\" rel=\"nofollow noopener\">YouTube<\/a><\/strong> and give it a thumbs up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/FUeqA9MAPZo?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n\n<p>Follow the step-by-step tutorial on how to create a Stacked Waterfall Chart Excel 2016 and make sure to download the Excel Workbook and follow along:<\/p>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/WATERFALL-CHART.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">WATERFALL-CHART.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1<\/strong><\/span>: Enter the values in your workbook with the <strong>Starting Total<\/strong> e.g. <em>January Income<\/em>.<\/p>\n<p>Then add the <strong>positive and negative values<\/strong>, like <em>direct &amp; indirect expenses<\/em>.<\/p>\n<p>Finally enter the <strong>Ending Total<\/strong> e.g. <em>February Income<\/em>, which will Sum all of the above values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/data-sum.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-3073\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/data-sum.jpg\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"365\" height=\"147\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/data-sum.jpg 365w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/data-sum-300x121.jpg 300w\" sizes=\"(max-width: 365px) 100vw, 365px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>Highlight all the data and go to <em><strong>Insert &gt; Recommended Charts<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/highlighted-data.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-3074\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/highlighted-data.jpg\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"365\" height=\"149\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/highlighted-data.jpg 365w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/highlighted-data-300x122.jpg 300w\" sizes=\"(max-width: 365px) 100vw, 365px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/insert-chart.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-3075\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/insert-chart.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"441\" height=\"138\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/insert-chart.png 441w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/insert-chart-300x94.png 300w\" sizes=\"(max-width: 441px) 100vw, 441px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Select <em><strong>All Charts &gt; Waterfall &gt; OK<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/waterfall.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-3076\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/waterfall.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"634\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/waterfall.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/waterfall-300x284.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span> <strong>Double Click on the Starting Totals column<\/strong> (<em>e.g. January Income<\/em>) and this will bring up the <em>Format Data Point<\/em> dialogue box.<\/p>\n<p><strong>&#8220;Check&#8221;\u00a0the Set as Total box<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-1-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-3078\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-1-1.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"398\" height=\"404\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-1-1.png 398w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-1-1-296x300.png 296w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<p><em>NB: This will\u00a0set this column&#8217;s value so it\u00a0starts on the horizontal axis at zero and will not\u00a0&#8220;float&#8221;<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span> Now <strong>select the Ending\u00a0Total<\/strong> <strong>with your mouse<\/strong> and once again,\u00a0<strong>&#8220;Check&#8221;\u00a0the Set as Total box<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-3079\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-2.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"295\" height=\"359\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-2.png 295w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-data-point-2-247x300.png 247w\" sizes=\"(max-width: 295px) 100vw, 295px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now you have your beautiful looking Excel 2016 Waterfall chart and you can quickly point out to your management where the variances have occurred&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone wp-image-3080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"765\" height=\"398\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall.png 765w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/final-waterfall-300x156.png 300w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>Example 2:<\/strong><\/span><\/p>\n<p>We will use the Waterfall Chart to understand the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/multi-step-income-statement\/\" target=\"_blank\" rel=\"noopener\">income statement<\/a> overview and change analysis.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-347.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18752\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-347.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"282\" height=\"285\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Select the <strong>Data Table<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-348.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18753\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-348.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"434\" height=\"411\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-348.png 434w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-348-300x284.png 300w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Insert<\/strong> &gt; <strong>Waterfall Icon<\/strong> &gt; <strong>Waterfall Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-349.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18754\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-349.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"902\" height=\"343\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-349.png 902w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-349-300x114.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-349-768x292.png 768w\" sizes=\"(max-width: 902px) 100vw, 902px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> <strong>Waterfall Chart <\/strong>will appear on the sheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-350.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18755\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-350.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"615\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-350.png 615w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-350-300x177.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<p>Net Sales, Gross Margin, Operating Income, Income before taxes, and Net Income are all either Total or Subtotal values, not additional values.<\/p>\n<p>As you can see Excel has incorrectly considered all the columns as additional values (color-coded as either blue or red). Let&#8217;s fix it!<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span> <strong>Right Click <\/strong>on Column and select<strong> Set as Total.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-351.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18756\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-351.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"713\" height=\"398\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-351.png 713w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-351-300x167.png 300w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/a><\/p>\n<p>Net Sales is now shown as Total Value (Green Color).<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5: <\/strong><\/span>Let&#8217;s do the same for Gross Margin, Operating Income, Income before taxes, and Net Income.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-352.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18757\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-352.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"615\" height=\"363\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-352.png 615w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-352-300x177.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5: <\/strong><\/span>Double Click on <strong>Chart title<\/strong> and rename it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-353.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18758\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-353.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"704\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-353.png 704w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-353-300x165.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6: <\/strong><\/span>To change the layout of the Waterfall Chart, Go to <strong>Chart Design<\/strong> &gt; Select a <strong>Chart Style<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-354.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18759\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-354.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"1181\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-354.png 1181w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-354-300x33.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-354-1024x112.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-354-768x84.png 768w\" sizes=\"(max-width: 1181px) 100vw, 1181px\" \/><\/a><\/p>\n<p>Your edited Waterfall Chart is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-355.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone size-full wp-image-18760\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-355.png\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"613\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-355.png 613w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-355-300x177.png 300w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>In this article, you have learned that the Waterfall in Excel 2016 <span data-story-id=\"story_b58bab7b0f5203e2f71a0449cd4f1f06\" data-room-id=\"room_d62db1d106bc54e2ee4e1d1ed91d580e\" data-timestamp=\"1595821249632\" data-text=\"is an excellent way to display how individual data contributes to an overall total.\" data-userid=\"1245285956862005248\" data-orgid=\"425304450073260032\">is an excellent way to display how individual data contributes to an overall total.<\/span><\/p>\n<div>\n<p>It is used to display how a net value has been arrived by analyzing the cumulative effect of positive and negative values based on a starting point.<\/p>\n<p>You can go through the details regarding the new charts available in Excel 2016 by<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/excel-2016-charts\/\" target=\"_blank\" rel=\"noopener noreferrer\">clicking here<\/a>.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/waterfalladdin\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Waterfall Chart\" class=\"alignnone wp-image-3082 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/MicrosoftExcelWaterfallChartCreatorTemplate.jpg\" alt=\"Create an Excel 2016 Waterfall Chart\" width=\"1200\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/MicrosoftExcelWaterfallChartCreatorTemplate.jpg 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/MicrosoftExcelWaterfallChartCreatorTemplate-300x100.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/MicrosoftExcelWaterfallChartCreatorTemplate-1024x341.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/MicrosoftExcelWaterfallChartCreatorTemplate-768x256.jpg 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Waterfall Charts are one of the many new Charts available only in Excel 2016. When I was working at General Electric, I had to create Excel 2016 Waterfall Charts on a monthly basis using formulas&#8230;.ouch! They are very popular in the current corporate environment as they graphically show the positive and negative movements within your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Create an Excel 2016 Waterfall Chart","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,127],"tags":[94],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3072"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3072"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3072\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/14882"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}