How do you Create a Waterfall Chart in Excel?

Waterfall chart, also known as cascading or bridge charts, are useful for understanding the cumulative effect of sequential data points. This type of chart helps in visualizing subtractions and additions over a period, giving you a clear picture of how individual elements contribute to the total.

Step 1: Open Microsoft Excel

1. Launch the Excel Application:
   • Open Microsoft Excel on your computer.
2. Open Your Workbook or Create a New One:
   • Click on File in the top-left corner.
   • Select Open to load an existing workbook or click on New to create a new workbook.

Step 2: Prepare Your Data

1. Enter or Organize Your Data:
   • Ensure you have your data organized in a list or table format.
   • Typically, you will have columns for the Category and Values.
2. Select Your Data:

Click and drag your mouse to select the range of cells that contain your data.

Step 3: Insert the Waterfall Chart

1. Go to the Insert Tab:
   • Navigate to the Insert tab in the Excel ribbon at the top of the screen.
2. Select Waterfall Chart:
   • In the Charts group, click on the Insert Waterfall or Stock Chart button.
   • From the dropdown menu, select Waterfall.

Step 4: Format the Waterfall Chart

1. Set the Starting and Ending Points:
   • Double-click on the Start and End data points in your chart.
   • In the right-side pane, check the box for Set as total to indicate that these points are cumulative totals.
2. Customize Colors and Styles:
   • Click on any of the bars in the chart to select them.
   • Right-click and choose Format Data Series.
   • In the Format Data Series pane, you can change the fill color, border, and other styles to make your chart more visually appealing.
3. Add Chart Elements:
   • Click on the chart to activate the Chart Tools on the ribbon.
   • Click Add Chart Element in the Design tab.
   • Choose to add axis titles, data labels, legend, gridlines, etc., as per your preference.

Step 5: Adjust Axis and Labels

1. Customize Axis:
   • Right-click on either the horizontal or vertical axis and select Format Axis.
   • In the Format Axis pane, adjust the bounds, units, and other settings to improve readability.
2. Modify Data Labels:
   • Right-click on any data label and select Format Data Labels.
   • Customize the label position, number format, and other settings.

Step 6: Fine-Tune the Chart

1. Resize and Reposition:
   • Click and drag the chart corners to resize.
   • Drag the entire chart to reposition it within your worksheet.
2. Modify Chart Title:
   • Double-click on the default chart title and type in your desired title.
   • Press Enter to finalize.

Step 7: Save Your Workbook

1. Save Your Work:
   • Click on File and select Save or Save As to store your changes.

Looking for a budget-friendly way to get Microsoft Office? Check out our affordable Office keys and save big on premium software!