{"id":14058,"date":"2016-10-18T10:20:00","date_gmt":"2016-10-18T08:20:00","guid":{"rendered":"https:\/\/www.xelplus.com\/?p=14058"},"modified":"2024-10-15T09:44:38","modified_gmt":"2024-10-15T07:44:38","slug":"easiest-waterfall-chart-in-excel-from-scratch","status":"publish","type":"post","link":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/","title":{"rendered":"How to Create a Waterfall Chart in Excel"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-download-the-free-chart-template-here-and-follow-along\">Download the free chart template \ud83d\udc49 <a href=\"https:\/\/app.monstercampaigns.com\/c\/ctfnx3oanlputpvycaj3\">HERE<\/a> and follow along.<\/h4>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-a-waterfall-chart\">What is a Waterfall Chart?<\/h2>\n\n\n\n<p>Waterfall charts show how an initial value changes over time. They use positive and negative factors. They are also known as bridge or cascade charts. They enable step-by-step data analysis.<\/p>\n\n\n\n<p>Waterfall graphs clearly show how gains and losses affect each other over time. This clarity makes them the top choice for visualizing data shifts.<\/p>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-does-a-waterfall-chart-work\">How Does a Waterfall Chart Work?<\/h2>\n\n\n\n<p>A waterfall chart is a powerful tool in business and finance. It shows how positive and negative values combine to make a final result. Here\u2019s how it works:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Starting Point<\/strong>: The chart starts with an initial value, like total revenue or a project budget. This value is displayed as the first bar on the chart.<\/li>\n\n\n\n<li><strong>Positive and Negative Changes<\/strong>: After the starting point, the chart shows intermediate steps. Each step is represented by a bar that goes up (positive change) or down (negative change). These bars show how different factors increase or decrease the initial value.<\/li>\n\n\n\n<li><strong>Cumulative Effect<\/strong>: As you move across the chart, each bar adds to or subtracts from the initial value. This cumulative effect helps you see the overall impact of each factor. The running total at each step shows how these changes add up over time.<\/li>\n\n\n\n<li><strong>Final Result<\/strong>: The last bar shows the final result, like net profit or total project cost. This final value shows the overall outcome. It considers all positive and negative changes.<\/li>\n<\/ul>\n\n\n\n<p>Here is an example:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall1.png\" alt=\"\" class=\"wp-image-25434 lazyload\"\/><noscript><img decoding=\"async\" width=\"947\" height=\"566\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall1.png\" alt=\"\" class=\"wp-image-25434 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall1.png 947w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall1-450x269.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall1-900x538.png 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall1-768x459.png 768w\" sizes=\"(max-width: 947px) 100vw, 947px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n<div id=\"block_94407caaff62b4f2c52c66e71ef935ee\" class=\"xelplus-block xelplus-block-course-cta \">\n<div class=\"course-cta-size-small overflow-hidden bg-\" style=\"background:#FAFAFA;\">\n\n  \n  <div class=\"course-cta-text p-10 lg:pl-22 lg:pr-0 lg:w-6\/12 text-center md:text-left\">\n\n    <p class=\"h5 uppercase\" style=\"color:#0693E3; \">Featured Course<\/p>\n\n    <h2>Professional Excel Charts for Business Reports<\/h2>\n\n    <div class=\"course-cta-excerpt max-w-sm mt-4 mb-6 sm-max:mx-auto font-semibold\">\n      Create professional charts that tell a story AND update automatically. Learn formulas and design techniques that get your reports noticed.    <\/div>\n\n    <a class=\"btn\" href=\"https:\/\/www.xelplus.com\/course\/business-excel-charts\/\" style=\"background:#0693E3; color:#fff;\">Learn More<\/a>\n\n  <\/div>\n\n    <div class=\"lg:w-6\/12\">\n    <img decoding=\"async\" width=\"900\" height=\"884\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-900x884.jpg\" class=\"attachment-large size-large lazyload\" alt=\"\" data-srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-900x884.jpg 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-450x442.jpg 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-768x755.jpg 768w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web.jpg 1150w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><noscript><img decoding=\"async\" width=\"900\" height=\"884\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-900x884.jpg\" class=\"attachment-large size-large lazyload\" alt=\"\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-900x884.jpg 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-450x442.jpg 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web-768x755.jpg 768w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/04\/Thumbnail_BusinessCharts_Large_web.jpg 1150w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/noscript>  <\/div>\n  \n<\/div>\n<\/div>\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-create-a-waterfall-chart-in-excel\">How to Create a Waterfall Chart in Excel<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-prepare-your-data\">Step 1: Prepare Your Data<\/h3>\n\n\n\n<p>Preparing your data correctly is crucial for creating an accurate Waterfall Chart. This involves setting up a cumulative series and specifying start and end values.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Start Value<\/strong>: Enter your initial value in cell C7 and reference it in cell E7<\/li>\n\n\n\n<li><strong>Up and Down Changes<\/strong>: Enter the changes (deltas) for each category in cells C8 to C12.<\/li>\n\n\n\n<li><strong>Cumulative Series<\/strong>: In cell D7, enter the formula =SUM($C$7:C7) and drag it down to fill the column. This will calculate the cumulative total at each stage.<\/li>\n\n\n\n<li><strong>Before Series<\/strong>: In cell F8, enter =D7 and drag down to cover all deltas.<\/li>\n\n\n\n<li><strong>After Series<\/strong>: In cell G8, enter =D8 and drag down to cover all deltas.<\/li>\n\n\n\n<li><strong>End Value<\/strong>: In cell E13, use the formula =D12 to get the final cumulative value.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall2.png\" alt=\"\" class=\"wp-image-25435 lazyload\"\/><noscript><img decoding=\"async\" width=\"1035\" height=\"567\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall2.png\" alt=\"\" class=\"wp-image-25435 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall2.png 1035w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall2-450x247.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall2-900x493.png 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall2-768x421.png 768w\" sizes=\"(max-width: 1035px) 100vw, 1035px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-step-2-create-the-waterfall-chart\">Step 2: Create the Waterfall Chart<\/h3>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<p>Now that your data is ready, you can create the Waterfall Chart.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select Data<\/strong>: Highlight cells B7 to B13, then hold down the <strong>Ctrl<\/strong>-key and select cells E7 to G13, including headers and empty cells for consistency.<\/li>\n\n\n\n<li><strong>Insert Column Chart<\/strong>: Go to the Insert tab, choose &#8220;Insert Column or Bar Chart,&#8221; and select &#8220;<strong>Clustered Column<\/strong>.&#8221;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall3.png\" alt=\"\" class=\"wp-image-25436 lazyload\"\/><noscript><img decoding=\"async\" width=\"857\" height=\"521\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall3.png\" alt=\"\" class=\"wp-image-25436 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall3.png 857w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall3-450x274.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall3-768x467.png 768w\" sizes=\"(max-width: 857px) 100vw, 857px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Change Chart Type<\/strong>: Right-click the selected area, choose &#8220;Change Series Chart Type,&#8221; and set the &#8220;Before&#8221; and &#8220;After&#8221; series to a <strong>Line chart<\/strong>. <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall4.1.png\" alt=\"\" class=\"wp-image-25438 lazyload\"\/><noscript><img decoding=\"async\" width=\"780\" height=\"736\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall4.1.png\" alt=\"\" class=\"wp-image-25438 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall4.1.png 780w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall4.1-450x425.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall4.1-768x725.png 768w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Add Up\/Down Bars<\/strong>: Select one of the line charts and click the &#8216;<strong>Plus<\/strong>&#8216; button on the top right of the chart. Check &#8220;<strong>Up\/Down Bars<\/strong>&#8221; to visually represent changes.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall5.png\" alt=\"\" class=\"wp-image-25439 lazyload\"\/><noscript><img decoding=\"async\" width=\"687\" height=\"417\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall5.png\" alt=\"\" class=\"wp-image-25439 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall5.png 687w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall5-450x273.png 450w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Adjust Gap Width<\/strong>: \n<ul class=\"wp-block-list\">\n<li>Select the Start &amp; End series and reduce Gap Width to a number of your liking (e.g., 100%). <\/li>\n\n\n\n<li>For the Up\/Down bars, select either the Before or After line chart and reduce the Gap Width to 100%.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Remove Lines<\/strong>: \n<ul class=\"wp-block-list\">\n<li>Click on the Before series and select &#8220;No line&#8221; from the Fill &amp; Line Options. <\/li>\n\n\n\n<li>Do the same for the After series.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall6.png\" alt=\"\" class=\"wp-image-25440 lazyload\"\/><noscript><img decoding=\"async\" width=\"687\" height=\"416\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall6.png\" alt=\"\" class=\"wp-image-25440 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall6.png 687w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall6-450x272.png 450w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n<div id=\"block_37ee45873f841e05fc72cba71d4ddbb8\" class=\"xelplus-block xelplus-block-course-cta \">\n<div class=\"course-cta-size-small overflow-hidden bg-blue-100\" >\n\n  \n  <div class=\"course-cta-text p-10 lg:pl-22 lg:pr-0 lg:w-6\/12 text-center md:text-left\">\n\n    <p class=\"h5 uppercase\" >Template Download<\/p>\n\n    <h2>Excel Waterfall Charts<\/h2>\n\n    <div class=\"course-cta-excerpt max-w-sm mt-4 mb-6 sm-max:mx-auto font-semibold\">\n      Quickly create impactful Waterfall Charts with our simple Excel templates. Just download, adjust to your needs, and your report is ready!    <\/div>\n\n    <a class=\"btn\" href=\"https:\/\/www.xelplus.com\/course\/waterfall-chart-templates\/\" >Learn More<\/a>\n\n  <\/div>\n\n    <div class=\"lg:w-6\/12\">\n    <img decoding=\"async\" width=\"900\" height=\"845\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-900x845.jpg\" class=\"attachment-large size-large lazyload\" alt=\"\" data-srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-900x845.jpg 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-450x423.jpg 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-768x721.jpg 768w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web.jpg 1148w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><noscript><img decoding=\"async\" width=\"900\" height=\"845\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-900x845.jpg\" class=\"attachment-large size-large lazyload\" alt=\"\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-900x845.jpg 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-450x423.jpg 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web-768x721.jpg 768w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/05\/Waterfall_Chart_Thumbnail_Large_Web.jpg 1148w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/noscript>  <\/div>\n  \n<\/div>\n<\/div>\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-step-3-customize-data-labels\">Step 3: Customize Data Labels<\/h3>\n\n\n\n<p>Customizing data labels will make your chart more informative. They show the value of each change directly on the chart.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Add Data Labels for Start and End Columns<\/strong>: Select the Start and End columns, right-click, and choose &#8220;Add Data Labels.&#8221;<\/li>\n\n\n\n<li><strong>Add Data Label Series<\/strong>: In cell H8, enter =MAX(F8:G8) and drag down to create a new series for data labels.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall7.1.png\" alt=\"\" class=\"wp-image-25441 lazyload\"\/><noscript><img decoding=\"async\" width=\"941\" height=\"363\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall7.1.png\" alt=\"\" class=\"wp-image-25441 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall7.1.png 941w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall7.1-450x174.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall7.1-900x347.png 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall7.1-768x296.png 768w\" sizes=\"(max-width: 941px) 100vw, 941px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Add to Chart<\/strong>: Right-click on your graph and select &#8220;Select Data.&#8221; Click &#8220;Add,&#8221; pick cell H6 as your series label, and range <strong>H7:H13<\/strong> as your series values. <\/li>\n\n\n\n<li><strong>Change to Scatter Plot<\/strong>: Right-mouse click on any series and select &#8220;Change Series Chart Type\u2026&#8221;. Find the Data label position series and change it to a Scatter Plot.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall8.1.png\" alt=\"\" class=\"wp-image-25443 lazyload\"\/><noscript><img decoding=\"async\" width=\"779\" height=\"459\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall8.1.png\" alt=\"\" class=\"wp-image-25443 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall8.1.png 779w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall8.1-450x265.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall8.1-768x453.png 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Position Data Labels<\/strong>: Click on the Data Label Position Series, activate data labels, and position them on top. Format as needed for clarity.<\/li>\n\n\n\n<li><strong>Set Data Labels to Show Values<\/strong>: Select the data labels, go to the data label options, and check &#8220;<strong>Value From Cells<\/strong>.&#8221; A pop-up will appear. Highlight cells <strong>C7:C13<\/strong> to select the values. <\/li>\n<\/ul>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"h-step-4-add-connectors\">Step 4: Add Connectors<\/h4>\n\n\n\n<p>Adding connectors will link the bars in your Waterfall Chart. This will make it easier to follow the flow of data changes.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Add Connector Series<\/strong>: Add a series for connectors using the cumulative series data. Use cell D6 for the series name and cells D7:D12 for the Y-values.  <\/li>\n\n\n\n<li><strong>Add Error Bars<\/strong>: Select the newly added series, click the Plus button, and check &#8220;Error Bars.&#8221; <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall10.png\" alt=\"\" class=\"wp-image-25444 lazyload\"\/><noscript><img decoding=\"async\" width=\"861\" height=\"370\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall10.png\" alt=\"\" class=\"wp-image-25444 lazyload\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall10.png 861w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall10-450x193.png 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall10-768x330.png 768w\" sizes=\"(max-width: 861px) 100vw, 861px\" \/><\/noscript><\/figure>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Format Error Bars<\/strong>: \n<ul class=\"wp-block-list\">\n<li>Hide the markers. <\/li>\n\n\n\n<li>Delete Y (vertical) error bars.<\/li>\n\n\n\n<li>Set direction to &#8216;<strong>Plus<\/strong>&#8216;. <\/li>\n\n\n\n<li>End style to &#8216;<strong>No Cap<\/strong>&#8216;.<\/li>\n\n\n\n<li>Error amount to a <strong>fixed<\/strong> value of <strong>1<\/strong>. <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<div id=\"block_5275f35293faea6796bc78c66eb46492\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-3 md:h-5 lg:h-7\"><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-step-5-final-touches\">Step 5: Final Touches<\/h3>\n\n\n\n<p>The final touches involve cleaning up your chart to make it visually appealing and easy to understand.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Adjust Colors and Borders<\/strong>: Click on color options for the X error bars and change the line color to a subtle grey. Ensure the connector line flows well by matching the color border for the Start\/End series and the Up and Down bars.<\/li>\n\n\n\n<li><strong>Remove Y-Axis<\/strong>: Click on the Y-axis and press Delete to remove it.<\/li>\n\n\n\n<li><strong>Remove Legends and Gridlines<\/strong>: Delete any legends at the bottom and gridlines for a cleaner look.<\/li>\n\n\n\n<li><strong>Add Title<\/strong>: Add a descriptive title to your chart.<\/li>\n\n\n\n<li><strong>Adjust Category Axis Labels<\/strong>: To ensure category axis labels move down if your cumulative values become negative, go to the X-axis options and set the Label Position to Low. Increase &#8216;Distance from axis&#8217; if needed. <\/li>\n<\/ul>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall11.png\" alt=\"\" class=\"wp-image-25446 lazyload\"\/><noscript><img decoding=\"async\" width=\"318\" height=\"389\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/07\/Waterfall11.png\" alt=\"\" class=\"wp-image-25446 lazyload\"\/><\/noscript><\/figure>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n\n<p>Using pre-made Waterfall Chart templates can save you time and ensure accuracy. These templates are easy to use and eliminate the need for complex setup and formatting. Get the <a href=\"https:\/\/www.xelplus.com\/course\/waterfall-chart-templates\/\" target=\"_blank\" rel=\"noreferrer noopener\">complete Waterfall Chart templates here<\/a>.<\/p>\n\n\n<div id=\"block_41af1aa1154164a10dd5c27343550caf\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-6 md:h-8 lg:h-12\"><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"download-the-chart-template\">Download the Chart Template<\/h2>\n\n\n\n<p>Enhance your learning experience by downloading our waterfall chart template. Practice the techniques discussed in real-time and master waterfall charts in Excel with a hands-on example. <a href=\"https:\/\/app.monstercampaigns.com\/c\/ctfnx3oanlputpvycaj3\">Download the template here<\/a> and start applying what you\u2019ve learned directly in Excel.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/app.monstercampaigns.com\/c\/ctfnx3oanlputpvycaj3\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/06\/DwonloadIcon_Excel_200PX.png\" alt=\"\" class=\"wp-image-24682 lazyload\"\/><noscript><img decoding=\"async\" width=\"200\" height=\"200\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2024\/06\/DwonloadIcon_Excel_200PX.png\" alt=\"\" class=\"wp-image-24682 lazyload\"\/><\/noscript><\/a><\/figure>\n\n\n<div id=\"block_364598870b0d2e28afb7f71e355ac46e\" class=\"xelplus-block xelplus-block-spacer \"><div class=\"h-2.5\"><\/div><\/div>\n\n<div id=\"block_c1b6115befa4d1ca8e51146b0400d2b2\" class=\"xelplus-block xelplus-block-course-cta \">\n<div class=\"course-cta-size-small overflow-hidden bg-\" style=\"background:#F3F4F4;\">\n\n  \n  <div class=\"course-cta-text p-10 lg:pl-22 lg:pr-0 lg:w-6\/12 text-center md:text-left\">\n\n    <p class=\"h5 uppercase\" style=\"color:#EC4C4C; \">Featured Bundle<\/p>\n\n    <h2>Black Belt Excel Bundle<\/h2>\n\n    <div class=\"course-cta-excerpt max-w-sm mt-4 mb-6 sm-max:mx-auto font-semibold\">\n      This Excel Black Belt Package includes EIGHT of our Popular Courses. \nYou&#8217;ll learn high-value, in-depth Excel skills that solve real problems.     <\/div>\n\n    <a class=\"btn\" href=\"https:\/\/www.xelplus.com\/course\/excel-black-belt\/\" style=\"background:#EC4C4C; color:#fff;\">Learn More<\/a>\n\n  <\/div>\n\n    <div class=\"lg:w-6\/12\">\n    <img decoding=\"async\" width=\"900\" height=\"900\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-900x900.jpg\" class=\"attachment-large size-large lazyload\" alt=\"Excel Black Belt Bundle XelPlus\" data-srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-900x900.jpg 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-450x450.jpg 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-280x280.jpg 280w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-768x768.jpg 768w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-360x360.jpg 360w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-720x720.jpg 720w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web.jpg 1024w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><noscript><img decoding=\"async\" width=\"900\" height=\"900\" src=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-900x900.jpg\" class=\"attachment-large size-large lazyload\" alt=\"Excel Black Belt Bundle XelPlus\" srcset=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-900x900.jpg 900w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-450x450.jpg 450w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-280x280.jpg 280w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-768x768.jpg 768w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-360x360.jpg 360w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web-720x720.jpg 720w, https:\/\/www.xelplus.com\/wp-content\/uploads\/2023\/02\/190925_Ultimate-Excel-Mastery-Bundle_Thumbnail_SQ_4_web.jpg 1024w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/noscript>  <\/div>\n  \n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Learn how to create a waterfall chart from scratch, using simple but unusual techniques. This version works with negative cumulative values and allows you to customize the data labels.<\/p>\n","protected":false},"author":3,"featured_media":4780,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"footnotes":""},"categories":[14,1],"tags":[1412,1409,135,571,648,1411],"class_list":["post-14058","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dashboards-charts-and-features","category-excel","tag-bridge-chart","tag-business-dashboard","tag-charts","tag-dashboard-techniques","tag-data-visualization","tag-waterfall-chart"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.2 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create a Waterfall Chart in Excel - Xelplus - Leila Gharani<\/title>\n<meta name=\"description\" content=\"Create an easy Waterfall Chart in Excel with our step-by-step guide. Download our free template for fast, professional results!\" \/>\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.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Waterfall Chart in Excel\" \/>\n<meta property=\"og:description\" content=\"Create an easy Waterfall Chart in Excel with our step-by-step guide. Download our free template for fast, professional results!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\" \/>\n<meta property=\"og:site_name\" content=\"Xelplus - Leila Gharani\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-18T08:20:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-15T07:44:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"458\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"Leila Gharani\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@leilagharani\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Leila Gharani\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\"},\"author\":{\"name\":\"Leila Gharani\",\"@id\":\"https:\/\/www.xelplus.com\/#\/schema\/person\/d8f19bb3303402013d3281b8979e4618\"},\"headline\":\"How to Create a Waterfall Chart in Excel\",\"datePublished\":\"2016-10-18T08:20:00+00:00\",\"dateModified\":\"2024-10-15T07:44:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\"},\"wordCount\":1060,\"publisher\":{\"@id\":\"https:\/\/www.xelplus.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif\",\"keywords\":[\"Bridge Chart\",\"Business Dashboard\",\"Charts\",\"Dashboard techniques\",\"data visualization\",\"Waterfall Chart\"],\"articleSection\":[\"Dashboards, Charts &amp; Features\",\"Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\",\"url\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\",\"name\":\"How to Create a Waterfall Chart in Excel - Xelplus - Leila Gharani\",\"isPartOf\":{\"@id\":\"https:\/\/www.xelplus.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif\",\"datePublished\":\"2016-10-18T08:20:00+00:00\",\"dateModified\":\"2024-10-15T07:44:38+00:00\",\"description\":\"Create an easy Waterfall Chart in Excel with our step-by-step guide. Download our free template for fast, professional results!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage\",\"url\":\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif\",\"contentUrl\":\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif\",\"width\":850,\"height\":458},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.xelplus.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Waterfall Chart in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.xelplus.com\/#website\",\"url\":\"https:\/\/www.xelplus.com\/\",\"name\":\"XelPlus - Leila Gharani\",\"description\":\"Bestselling Excel and Power BI Courses\",\"publisher\":{\"@id\":\"https:\/\/www.xelplus.com\/#organization\"},\"alternateName\":\"XelPlus\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.xelplus.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.xelplus.com\/#organization\",\"name\":\"XelPlus\",\"alternateName\":\"Leila Gharani\",\"url\":\"https:\/\/www.xelplus.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.xelplus.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2019\/12\/XelPlus-favicon-114px.png\",\"contentUrl\":\"https:\/\/www.xelplus.com\/wp-content\/uploads\/2019\/12\/XelPlus-favicon-114px.png\",\"width\":114,\"height\":114,\"caption\":\"XelPlus\"},\"image\":{\"@id\":\"https:\/\/www.xelplus.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.xelplus.com\/#\/schema\/person\/d8f19bb3303402013d3281b8979e4618\",\"name\":\"Leila Gharani\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.xelplus.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/42e34befbcef0b5f8b2bb0e81567af28bbe25f74996b704194aaed8a474589ab?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/42e34befbcef0b5f8b2bb0e81567af28bbe25f74996b704194aaed8a474589ab?s=96&d=mm&r=g\",\"caption\":\"Leila Gharani\"},\"description\":\"I\u2019ve spent over 20 years helping businesses use data to improve their results. I've worked as an economist and a consultant. I spent 12 years in corporate roles across finance, operations, and IT\u2014managing SAP and Oracle projects. As a 7-time Microsoft MVP, I have deep knowledge of tools like Excel and Power BI. I love making complex tech topics easy to understand. There\u2019s nothing better than helping someone realize they can do it themselves. I\u2019m always learning new things too and finding better ways to help others succeed.\",\"sameAs\":[\"https:\/\/www.instagram.com\/lgharani\/\",\"https:\/\/www.linkedin.com\/in\/leila-gharani-6b12506\/?ppe=1\",\"https:\/\/x.com\/leilagharani\",\"https:\/\/www.youtube.com\/channel\/UCJtUOos_MwJa_Ewii-R3cJA\"],\"url\":\"https:\/\/www.xelplus.com\/author\/xelplus\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create a Waterfall Chart in Excel - Xelplus - Leila Gharani","description":"Create an easy Waterfall Chart in Excel with our step-by-step guide. Download our free template for fast, professional results!","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.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Waterfall Chart in Excel","og_description":"Create an easy Waterfall Chart in Excel with our step-by-step guide. Download our free template for fast, professional results!","og_url":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/","og_site_name":"Xelplus - Leila Gharani","article_published_time":"2016-10-18T08:20:00+00:00","article_modified_time":"2024-10-15T07:44:38+00:00","og_image":[{"width":850,"height":458,"url":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif","type":"image\/gif"}],"author":"Leila Gharani","twitter_card":"summary_large_image","twitter_creator":"@leilagharani","twitter_misc":{"Written by":"Leila Gharani","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#article","isPartOf":{"@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/"},"author":{"name":"Leila Gharani","@id":"https:\/\/www.xelplus.com\/#\/schema\/person\/d8f19bb3303402013d3281b8979e4618"},"headline":"How to Create a Waterfall Chart in Excel","datePublished":"2016-10-18T08:20:00+00:00","dateModified":"2024-10-15T07:44:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/"},"wordCount":1060,"publisher":{"@id":"https:\/\/www.xelplus.com\/#organization"},"image":{"@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage"},"thumbnailUrl":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif","keywords":["Bridge Chart","Business Dashboard","Charts","Dashboard techniques","data visualization","Waterfall Chart"],"articleSection":["Dashboards, Charts &amp; Features","Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/","url":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/","name":"How to Create a Waterfall Chart in Excel - Xelplus - Leila Gharani","isPartOf":{"@id":"https:\/\/www.xelplus.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage"},"image":{"@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage"},"thumbnailUrl":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif","datePublished":"2016-10-18T08:20:00+00:00","dateModified":"2024-10-15T07:44:38+00:00","description":"Create an easy Waterfall Chart in Excel with our step-by-step guide. Download our free template for fast, professional results!","breadcrumb":{"@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#primaryimage","url":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif","contentUrl":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2016\/10\/Easiest-Waterfall-Chart-in-Excel-From-Scratch-works-with-negative-cumulative-values.gif","width":850,"height":458},{"@type":"BreadcrumbList","@id":"https:\/\/www.xelplus.com\/easiest-waterfall-chart-in-excel-from-scratch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.xelplus.com\/"},{"@type":"ListItem","position":2,"name":"How to Create a Waterfall Chart in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.xelplus.com\/#website","url":"https:\/\/www.xelplus.com\/","name":"XelPlus - Leila Gharani","description":"Bestselling Excel and Power BI Courses","publisher":{"@id":"https:\/\/www.xelplus.com\/#organization"},"alternateName":"XelPlus","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.xelplus.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.xelplus.com\/#organization","name":"XelPlus","alternateName":"Leila Gharani","url":"https:\/\/www.xelplus.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xelplus.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2019\/12\/XelPlus-favicon-114px.png","contentUrl":"https:\/\/www.xelplus.com\/wp-content\/uploads\/2019\/12\/XelPlus-favicon-114px.png","width":114,"height":114,"caption":"XelPlus"},"image":{"@id":"https:\/\/www.xelplus.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.xelplus.com\/#\/schema\/person\/d8f19bb3303402013d3281b8979e4618","name":"Leila Gharani","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xelplus.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/42e34befbcef0b5f8b2bb0e81567af28bbe25f74996b704194aaed8a474589ab?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/42e34befbcef0b5f8b2bb0e81567af28bbe25f74996b704194aaed8a474589ab?s=96&d=mm&r=g","caption":"Leila Gharani"},"description":"I\u2019ve spent over 20 years helping businesses use data to improve their results. I've worked as an economist and a consultant. I spent 12 years in corporate roles across finance, operations, and IT\u2014managing SAP and Oracle projects. As a 7-time Microsoft MVP, I have deep knowledge of tools like Excel and Power BI. I love making complex tech topics easy to understand. There\u2019s nothing better than helping someone realize they can do it themselves. I\u2019m always learning new things too and finding better ways to help others succeed.","sameAs":["https:\/\/www.instagram.com\/lgharani\/","https:\/\/www.linkedin.com\/in\/leila-gharani-6b12506\/?ppe=1","https:\/\/x.com\/leilagharani","https:\/\/www.youtube.com\/channel\/UCJtUOos_MwJa_Ewii-R3cJA"],"url":"https:\/\/www.xelplus.com\/author\/xelplus\/"}]}},"_links":{"self":[{"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/posts\/14058","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/comments?post=14058"}],"version-history":[{"count":5,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/posts\/14058\/revisions"}],"predecessor-version":[{"id":26398,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/posts\/14058\/revisions\/26398"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/media\/4780"}],"wp:attachment":[{"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/media?parent=14058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/categories?post=14058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xelplus.com\/wp-json\/wp\/v2\/tags?post=14058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}