Now select the orange bars and do a right-click click on the “fill” option available, select “No fill”. The blue color appears on the up, and orange appears at the bottom.
Click on “Accumulation” and then click on “up arrow” as marked with red color. When you click the “Select Data”, one menu will pop up as below. Select the chart or bars and right-click you will get the pop-up menu from that menu, select the “Select data” option.
Now we need to convert this stack chart to a waterfall chart with the below steps. Now select the entire data range go to insert >charts >column >under column chart > select Stacked column as shown in the below screenshot. Now copy the formula to all other months as shown in the below screenshot so that we will get the accumulated sales of each month. Later insert the formula for the addition of January sales to February sales in the accumulation row under the February column, as shown in the below screenshot.
