Once your data is prepared, it’s time to create the chart. Select the date and height columns, then navigate to the Insert tab in Excel. From there, choose a 2D column chart.

When you create Waterfall Charts in Excel, ... Manually add totals and subtotals to your data before creating the chart. This will help in clearly showing the cumulative effect of the data points. 6.

There's an easy way to create stacked bar charts in Excel. The real challenge is organizing data to make sure everything shows up as effectively as possible.