{"id":4949,"date":"2023-10-16T08:49:52","date_gmt":"2023-10-16T08:49:52","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=4949"},"modified":"2025-07-18T13:55:21","modified_gmt":"2025-07-18T08:25:21","slug":"stacked-waterfall-chart-in-excel-step-by-step-tutorial","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/","title":{"rendered":"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial"},"content":{"rendered":"<p><b>Summary:<\/b><span style=\"font-weight: 400;\"> Discover how to craft a Stacked Waterfall Chart in Excel with our comprehensive guide. This tutorial covers data preparation, chart creation, and formatting to help you visualise financial data effectively.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Understanding_Stacked_Waterfall_Charts\" >Understanding Stacked Waterfall Charts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Preparing_Your_Data\" >Preparing Your Data<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Gather_Your_Data\" >Gather Your Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Arrange_Your_Data_in_the_Required_Format\" >Arrange Your Data in the Required Format<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Creating_a_Stacked_Waterfall_Chart_in_Excel\" >Creating a Stacked Waterfall Chart in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Beautification_of_the_Chart\" >Beautification of the Chart<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#How_do_I_create_a_Stacked_Waterfall_Chart_in_Excel\" >How do I create a Stacked Waterfall Chart in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#What_is_the_purpose_of_a_Stacked_Waterfall_Chart\" >What is the purpose of a Stacked Waterfall Chart?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Can_I_use_a_Stacked_Waterfall_Chart_for_financial_analysis\" >Can I use a Stacked Waterfall Chart for financial analysis?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><b>Introduction<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">If you have been wondering how to create a <\/span><a href=\"https:\/\/chartexpo.com\/blog\/stacked-waterfall-chart-in-excel#:~:text=Definition%3A%20A%20stacked%20Waterfall%20Chart,to%20show%20the%20data%20points.\" rel=\"nofollow\"><span style=\"font-weight: 400;\">Stacked Waterfall Chart<\/span><\/a><span style=\"font-weight: 400;\"> in <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_Excel\" rel=\"nofollow\"><span style=\"font-weight: 400;\">Excel<\/span><\/a><span style=\"font-weight: 400;\">, your search ends here. This in-depth guide will explore the details of making attractive stacked waterfall charts in Excel.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Financial and other revenue or sales data is represented using stacked <\/span><a href=\"https:\/\/pickl.ai\/blog\/how-to-create-waterfall-chart-in-excel\/\"><span style=\"font-weight: 400;\">waterfall charts<\/span><\/a><span style=\"font-weight: 400;\">, which may also be used to track changes over time and analyse the cumulative impacts of numerous causes.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">With my detailed, step-by-step instructions and seasoned guidance, you will learn to create these informative charts like a pro.<\/span><\/p>\n<p><b>Read Blogs:\u00a0<\/b><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/vba-in-excel\/\"><span style=\"font-weight: 400;\">Master VBA in Excel: Essential Tips and Tricks for Beginners<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/conquering-concatenation-mastering-text-combining-in-excel\/\"><span style=\"font-weight: 400;\">Conquering Concatenation: Mastering Text Combining in Excel<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2 id=\"understanding-stacked-waterfall-charts\"><span class=\"ez-toc-section\" id=\"Understanding_Stacked_Waterfall_Charts\"><\/span><b>Understanding Stacked Waterfall Charts<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Understanding the idea of stacked waterfall charts is essential before proceeding with the design process. These graphs show a sequence of positive and negative values that add up to a total.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">These infographics very well illustrate the flow of money, expenses, or any other <a href=\"https:\/\/www.pickl.ai\/blog\/qualitative-and-quantitative-data\/\">quantitative data.<\/a> For financial analysts and other business professionals, stacked waterfall charts are useful tools because they let you pinpoint specific components inside a dataset.<\/span><\/p>\n<p><b>Explore More:\u00a0<\/b><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/master-excels-hlookup-the-ultimate-guide-to-finding-data-faster\/\"><span style=\"font-weight: 400;\">Master Excel\u2019s HLOOKUP: The Ultimate Guide to Finding Data Faster<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/how-to-use-count-in-excel-a-guide-to-the-count-function\/\"><span style=\"font-weight: 400;\">How to Use Count In Excel: A Guide to The COUNT Function<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/mis-report-in-excel-definition-types-how-to-create\/\"><span style=\"font-weight: 400;\">MIS Report in Excel? Definition, Types &amp; How to Create<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2 id=\"preparing-your-data\"><span class=\"ez-toc-section\" id=\"Preparing_Your_Data\"><\/span><b>Preparing Your Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The foundation of a great stacked waterfall chart lies in clean and organised data. Here\u2019s how you should prepare your data for this task:<\/span><\/p>\n<h3 id=\"gather-your-data\"><span class=\"ez-toc-section\" id=\"Gather_Your_Data\"><\/span><b>Gather Your Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Suppose you must present the quarter-on-quarter revenue data for 3 cities where your company does business to the executive leadership team. The data is shown in the below picture:<\/span><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/Gather-Your-Data.png\" alt=\"Gather Your Data\" width=\"752\" height=\"218\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><br \/>Instead of a simple stacked column chart, you want to show a quarter-on-quarter cumulative roll-up chart, a Stacked Waterfall Chart, so that it shows clear insights to the top management about each city\u2019s revenue contribution for each period.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">But, no readymade Stacked Waterfall Chart is available in Excel.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">So, how do we create such a chart? Well, we will use some simple tricks here to convert a normal stacked column chart into a Stacked Waterfall Chart. Let\u2019s begin by preparing the data in the required format.<\/span><\/p>\n<h3 id=\"arrange-your-data-in-the-required-format\"><span class=\"ez-toc-section\" id=\"Arrange_Your_Data_in_the_Required_Format\"><\/span><b>Arrange Your Data in the Required Format<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">First, you need to arrange the data in the below manner:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Add a row below the table and name it as, say \u2013 accumulated\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Put 0 value in the first cell of this row that is, for the Opening column (cell C7)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use the formula [ <\/span><i><span style=\"font-weight: 400;\">=SUM(C4:C7) <\/span><\/i><span style=\"font-weight: 400;\">] in cell D7, which will create the base value for each of the quarters, which is the closing value for the earlier quarter exactly the way a Bridge Chart or a Stacked Waterfall Chart represents the data<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\"><img decoding=\"async\" class=\"size-full wp-image-13346 alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2.png\" alt=\"Stacked Waterfall Chart in Excel \" width=\"730\" height=\"316\" srcset=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2.png 730w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-300x130.png 300w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-110x48.png 110w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-200x87.png 200w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-380x164.png 380w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-255x110.png 255w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-550x238.png 550w, https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image6-2-150x65.png 150w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Now, drag this formula for all the time periods, that is, until Qtr4 or until cell G7 in this case.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">This Accumulated row\u2019s value represents the opening value for that quarter or the closing value for the earlier quarter. For example, Qtr2 started with 470 USD revenue, and during the quarter 2 period, its three cities, Delhi, Noida, and Gurugram, generated 150, 120, and 90 USD, respectively.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Now, add a column for closing values. This new column is named \u201cClosing,\u201d as shown in the picture below.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone\" style=\"font-size: revert;\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/Bridge-chart.png\" alt=\"Bridge chart\" width=\"865\" height=\"339\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Values for the calls of the Closing column should represent the total of the respective rows. For doing so, use the formula [<\/span><i><span style=\"font-weight: 400;\"> =SUM(C4:G4) <\/span><\/i><span style=\"font-weight: 400;\">] in cell H4<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Now drag this formula till cell H6.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In the above case, leave the grand total cell, cell H7, blank. Your data is now ready to create a nice Stacked Waterfall Chart.<\/span><\/li>\n<\/ul>\n<p><b>Also Check:<\/b> <a href=\"https:\/\/pickl.ai\/blog\/data-validation-in-ms-excel\/\"><span style=\"font-weight: 400;\">Data Validation in MS Excel: A Guide<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2 id=\"creating-a-stacked-waterfall-chart-in-excel\"><span class=\"ez-toc-section\" id=\"Creating_a_Stacked_Waterfall_Chart_in_Excel\"><\/span><b>Creating a Stacked Waterfall Chart in Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Now, let\u2019s jump into the practical part of creating a stacked waterfall chart in Excel. Follow the below steps:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select the entire data table from cell B 3 to cell H 7\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on the <\/span><i><span style=\"font-weight: 400;\">Insert<\/span><\/i><span style=\"font-weight: 400;\"> tab (shown with yellow highlighter)\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Go to the <\/span><i><span style=\"font-weight: 400;\">Chart <\/span><\/i><span style=\"font-weight: 400;\">section and click on the <\/span><i><span style=\"font-weight: 400;\">Insert Column or Bar Chart <\/span><\/i><span style=\"font-weight: 400;\">icon<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">From the drop-down menu, select the <\/span><i><span style=\"font-weight: 400;\">stacked column chart<\/span><\/i><span style=\"font-weight: 400;\"> (shown in red underlined) under <\/span><i><span style=\"font-weight: 400;\">2-D Column<\/span><\/i><span style=\"font-weight: 400;\"> type charts (highlighted in yellow)<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/Creating-a-Stacked-Waterfall-Chart-in-Excel.png\" alt=\"Creating a Stacked Waterfall Chart in Excel\" width=\"1113\" height=\"543\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">If you follow these steps, as shown in the above picture, a normal stacked column chart will appear, as shown in the image below.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/normal-stacked-column-chart.png\" alt=\"normal stacked column chart\" width=\"600\" height=\"278\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Now, we will use a few useful tricks to convert the above-stacked column chart into a Stacked Waterfall Chart.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">First, click anywhere on the chart so that the chart area is selected, and then right-click to open the popup.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click on the <\/span><i><span style=\"font-weight: 400;\">Select Data <\/span><\/i><span style=\"font-weight: 400;\">as shown below with a Red underline.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/excel-cahrt.png\" alt=\"excel cahrt\" width=\"1431\" height=\"725\" \/><\/p>\n<ul>\n<li>The below popup window will be opened<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/stacked-waterfall-chart-with-multiple-series-excel.png\" alt=\"stacked waterfall chart with multiple series excel\" width=\"1468\" height=\"725\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Now select the last item, that is, <\/span><i><span style=\"font-weight: 400;\">Accumulated <\/span><\/i><span style=\"font-weight: 400;\">(shown as Blue highlighted), and click on the <\/span><i><span style=\"font-weight: 400;\">UP Arrow <\/span><\/i><span style=\"font-weight: 400;\">button (circled in red) until this particular item comes to the top.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">The window will look like the below picture.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click on OK.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/select-data-source.png\" alt=\"select data source\" width=\"884\" height=\"482\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Your stacked column chart will be transformed once you take the Accumulated column to the top.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Now, instead of the Accumulated parts (a yellow stacked portion of the column bar) coming to the upper part of the columns, they will now be shown in the bottom part of each column and will form the base of the opening value for each period, as shown in the picture below.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/normal-stacked-column-chart.png\" alt=\"normal stacked column chart\" width=\"600\" height=\"278\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Now single-click on the yellow part of the column to select all yellow stacked portions.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Right-click on any of the yellow parts and click on the <\/span><i><span style=\"font-weight: 400;\">Format Data Series.<\/span><\/i><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/format-data-series.png\" alt=\"format data series\" width=\"1560\" height=\"767\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">The format window will be opened as a panel on the right side, as shown below.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/stacked.png\" alt=\"stacked\" width=\"1302\" height=\"553\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Click on the first icon (Fill and Line), encircled by red in the above picture.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select the <\/span><i><span style=\"font-weight: 400;\">No Fill <\/span><\/i><span style=\"font-weight: 400;\">option (underlined in red)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once you follow the above steps and close this Format panel, the Accumulated portion of each stacked column bar will vanish, and the chart will start looking like a Stacked Waterfall Chart, as shown in the picture below.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/waterfall-chart-excel.png\" alt=\"waterfall chart excel\" width=\"1453\" height=\"688\" \/><\/p>\n<h3 id=\"beautification-of-the-chart\"><span class=\"ez-toc-section\" id=\"Beautification_of_the_Chart\"><\/span><b>Beautification of the Chart<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Let\u2019s beautify this chart to look exactly like a stacked waterfall chart. To do so, follow the below steps:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Click on any of the gridlines and delete them.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select the Accumulated or the base values and delete those values.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">The chart will start looking like the one below.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/Beautification-of-the-Chart.png\" alt=\"Beautification of the Chart\" width=\"1453\" height=\"688\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Now, click on the Chart Title and change the name to a suitable title that reflects the chart&#8217;s meaningful nature.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">I named the chart \u201cZone-wise Quarterly Stacked Profit Chart\u201d<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select each series of the data labels and change their font to Bold and font color to white<\/span><\/li>\n<li><span style=\"font-weight: 400;\">The final Stacked waterfall Chart will look as shown in the picture below. It provides the opening profit for each city and how each city performed on a quarter-on-quarter basis.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">At the end of the year, what was the accumulated closing profit for the entire company, and what was each city\u2019s contribution to it?<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/zone-wise-quaterly.png\" alt=\"zone wise quaterly\" width=\"1357\" height=\"736\" \/><\/p>\n<p><b>Further Read:\u00a0<\/b><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/how-to-become-a-certified-microsoft-excel-expert\/\"><span style=\"font-weight: 400;\">How to Become a Certified Microsoft Excel Expert?<\/span><\/a><\/p>\n<p><a href=\"https:\/\/pickl.ai\/blog\/excel-keyboard-shortcuts\/\"><span style=\"font-weight: 400;\">Essential Keyboard Shortcuts in MS Excel<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h2 id=\"frequently-asked-questions\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><b>Frequently Asked Questions<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 id=\"how-do-i-create-a-stacked-waterfall-chart-in-excel\"><span class=\"ez-toc-section\" id=\"How_do_I_create_a_Stacked_Waterfall_Chart_in_Excel\"><\/span><b>How do I create a Stacked Waterfall Chart in Excel?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">To create a Stacked Waterfall Chart in Excel, first prepare your data by adding accumulated and closing value columns. Insert a stacked column chart, then format it by moving the accumulated series to the bottom and removing its fill. Adjust data labels and gridlines to finalise the chart.<\/span><\/p>\n<h3 id=\"what-is-the-purpose-of-a-stacked-waterfall-chart\"><span class=\"ez-toc-section\" id=\"What_is_the_purpose_of_a_Stacked_Waterfall_Chart\"><\/span><b>What is the purpose of a Stacked Waterfall Chart?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">A Stacked Waterfall Chart is used to visually represent how sequential positive and negative values contribute to a total over time. It\u2019s beneficial for financial analysis, as it illustrates how various factors affect cumulative totals, making it easier to understand changes in revenue, expenses, or other metrics.<\/span><\/p>\n<h3 id=\"can-i-use-a-stacked-waterfall-chart-for-financial-analysis\"><span class=\"ez-toc-section\" id=\"Can_I_use_a_Stacked_Waterfall_Chart_for_financial_analysis\"><\/span><b>Can I use a Stacked Waterfall Chart for financial analysis?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Yes, Stacked Waterfall Charts are excellent for financial analysis. They effectively depict how various economic elements, such as revenue or expenses, impact the total. By visualising these sequential changes, you gain clearer insights into the contributions and effects of each component on financial performance over time.<\/span><\/p>\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><b>Conclusion<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Mastering creating Stacked Waterfall <a href=\"https:\/\/www.pickl.ai\/blog\/advanced-excel-chart-types\/\">Charts in Excel<\/a> can significantly enhance your data analysis and presentation skills. Following our step-by-step guide and implementing our expert tips, you will be well-equipped to create impactful charts that effectively convey complex financial data.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Stacked Waterfall Charts can be a game-changer for your reports, presentations, and business insights. So, try to unlock the power of data visualisation with Excel.<\/span><\/p>\n<p><b>Also Look At:<\/b> <a href=\"https:\/\/pickl.ai\/blog\/use-of-excel-in-data-analysis\/\"><span style=\"font-weight: 400;\">Use of Excel in Data Analysis<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"Master Excel\u2019s Stacked Waterfall Chart: Transform your data into clear, insightful visuals with our easy, step-by-step guide.\n","protected":false},"author":15,"featured_media":14099,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1351],"tags":[1768,1770,1765,1767,1766,1764,1769],"ppma_author":[2182,2604],"class_list":{"0":"post-4949","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-microsoft-excel","8":"tag-excel-waterfall-chart-with-multiple-series","9":"tag-free-stacked-waterfall-chart-in-excel","10":"tag-how-do-i-create-a-double-waterfall-chart-in-excel","11":"tag-how-do-i-create-a-subtotal-waterfall-chart-in-excel","12":"tag-how-do-i-do-a-stacked-chart-in-excel","13":"tag-stacked-waterfall-chart-in-excel","14":"tag-waterfall-chart-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Create a Stacked Waterfall Chart in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to create a Stacked Waterfall Chart in Excel with our step-by-step guide. Perfect for visualising financial data effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a Stacked Waterfall Chart in Excel with our step-by-step guide. Perfect for visualising financial data effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-16T08:49:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-18T08:25:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Biswadip Banerjee, Abhinav Anand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Biswadip Banerjee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/\"},\"author\":{\"name\":\"Biswadip Banerjee\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c6b43cd34b67b5ff9a4fb781e93214b6\"},\"headline\":\"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial\",\"datePublished\":\"2023-10-16T08:49:52+00:00\",\"dateModified\":\"2025-07-18T08:25:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/\"},\"wordCount\":1436,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/image12-1.jpg\",\"keywords\":[\"excel waterfall chart with multiple series\",\"Free stacked waterfall chart in excel\",\"How do I create a double waterfall chart in Excel?\",\"How do I create a subtotal waterfall chart in Excel?\",\"How do I do a stacked chart in Excel?\",\"Stacked waterfall chart in Excel\",\"waterfall chart excel\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/\",\"name\":\"How to Create a Stacked Waterfall Chart in Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/image12-1.jpg\",\"datePublished\":\"2023-10-16T08:49:52+00:00\",\"dateModified\":\"2025-07-18T08:25:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c6b43cd34b67b5ff9a4fb781e93214b6\"},\"description\":\"Learn how to create a Stacked Waterfall Chart in Excel with our step-by-step guide. Perfect for visualising financial data effectively.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/image12-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/image12-1.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Stacked waterfall chart in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/microsoft-excel\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c6b43cd34b67b5ff9a4fb781e93214b6\",\"name\":\"Biswadip Banerjee\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/avatar_user_15_1695708604-96x96.jpg3e5a43f47a363de437430030cd89f77c\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/avatar_user_15_1695708604-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/avatar_user_15_1695708604-96x96.jpg\",\"caption\":\"Biswadip Banerjee\"},\"description\":\"I am an analytics consultant, working closely with clients in the Irish Telecom industry. With more than 15 years of work experience, I also have found my passion in writing. I contribute to Addhyyan Book Publisher and also self-publish on Amazon Kindle. My published works include \\\"Leadership By Hypnosis: How To Hypnotize And Influence\\\" and \\\"10 Goosebumps Stories,\\\" a collection of thrilling horror and supernatural tales. My writing often delves into the exciting realm of technology trends and their future implications.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/biswadip-banerjee\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create a Stacked Waterfall Chart in Excel","description":"Learn how to create a Stacked Waterfall Chart in Excel with our step-by-step guide. Perfect for visualising financial data effectively.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial","og_description":"Learn how to create a Stacked Waterfall Chart in Excel with our step-by-step guide. Perfect for visualising financial data effectively.","og_url":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/","og_site_name":"Pickl.AI","article_published_time":"2023-10-16T08:49:52+00:00","article_modified_time":"2025-07-18T08:25:21+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg","type":"image\/jpeg"}],"author":"Biswadip Banerjee, Abhinav Anand","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Biswadip Banerjee","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/"},"author":{"name":"Biswadip Banerjee","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c6b43cd34b67b5ff9a4fb781e93214b6"},"headline":"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial","datePublished":"2023-10-16T08:49:52+00:00","dateModified":"2025-07-18T08:25:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/"},"wordCount":1436,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg","keywords":["excel waterfall chart with multiple series","Free stacked waterfall chart in excel","How do I create a double waterfall chart in Excel?","How do I create a subtotal waterfall chart in Excel?","How do I do a stacked chart in Excel?","Stacked waterfall chart in Excel","waterfall chart excel"],"articleSection":["Microsoft Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/","url":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/","name":"How to Create a Stacked Waterfall Chart in Excel","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg","datePublished":"2023-10-16T08:49:52+00:00","dateModified":"2025-07-18T08:25:21+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c6b43cd34b67b5ff9a4fb781e93214b6"},"description":"Learn how to create a Stacked Waterfall Chart in Excel with our step-by-step guide. Perfect for visualising financial data effectively.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg","width":1200,"height":628,"caption":"Stacked waterfall chart in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/stacked-waterfall-chart-in-excel-step-by-step-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel","item":"https:\/\/www.pickl.ai\/blog\/category\/microsoft-excel\/"},{"@type":"ListItem","position":3,"name":"Stacked Waterfall Chart in Excel: Step-by-Step Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c6b43cd34b67b5ff9a4fb781e93214b6","name":"Biswadip Banerjee","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_15_1695708604-96x96.jpg3e5a43f47a363de437430030cd89f77c","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_15_1695708604-96x96.jpg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_15_1695708604-96x96.jpg","caption":"Biswadip Banerjee"},"description":"I am an analytics consultant, working closely with clients in the Irish Telecom industry. With more than 15 years of work experience, I also have found my passion in writing. I contribute to Addhyyan Book Publisher and also self-publish on Amazon Kindle. My published works include \"Leadership By Hypnosis: How To Hypnotize And Influence\" and \"10 Goosebumps Stories,\" a collection of thrilling horror and supernatural tales. My writing often delves into the exciting realm of technology trends and their future implications.","url":"https:\/\/www.pickl.ai\/blog\/author\/biswadip-banerjee\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/image12-1.jpg","authors":[{"term_id":2182,"user_id":15,"is_guest":0,"slug":"biswadip-banerjee","display_name":"Biswadip Banerjee","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_15_1695708604-96x96.jpg","first_name":"Biswadip","user_url":"","last_name":"Banerjee","description":"I am an analytics consultant, working closely with clients in the Irish Telecom industry. With more than 15 years of work experience, I also have found my passion in writing. I contribute to Addhyyan Book Publisher and also self-publish on Amazon Kindle. My published works include \"Leadership By Hypnosis: How To Hypnotize And Influence\" and \"10 Goosebumps Stories,\" a collection of thrilling horror and supernatural tales. My writing often delves into the exciting realm of technology trends and their future implications."},{"term_id":2604,"user_id":44,"is_guest":0,"slug":"abhinavanand","display_name":"Abhinav Anand","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_44_1721991827-96x96.jpeg","first_name":"Abhinav","user_url":"","last_name":"Anand","description":"Abhinav Anand expertise lies in Data Analysis and SQL, Python and Data Science. Abhinav Anand graduated from IIT (BHU) Varanansi in Electrical Engineering  and did his masters from IIT (BHU) Varanasi. Abhinav has hobbies like Photography,Travelling and narrating stories."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/4949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=4949"}],"version-history":[{"count":29,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/4949\/revisions"}],"predecessor-version":[{"id":23293,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/4949\/revisions\/23293"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/14099"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=4949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=4949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=4949"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=4949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}