How to create a stacked bar chart in Excel?

Here’s how you can create a waterfall chart in:

Method 1: Using Built-in Waterfall Chart

• Prepare Your Data – Arrange your data with categories and values.
• Insert a Waterfall Chart – Select your data, go to Insert > Charts > Waterfall.
• Set Totals – Right-click the first and last bars, then select Set as Total.
• Customize the Chart – Adjust colors, labels, and remove unnecessary elements.

Method 2: Using a Stacked Column Chart

• Create Helper Columns – Add columns for base, increase, and decrease values.
• Insert a Stacked Column Chart – Select your data and go to Insert > Column Chart > Stacked Column.
• Format the Chart – Adjust transparency, colors, and labels to resemble a waterfall chart.

To create a pie chart in excel you should:

• Select the data.
• Select Insert: insert pie or doughnut chart.
• Select the chart and customize by adding data labels, colors and text.