Create a waterfall chart
-
Select your data.
-
Click Insert > Insert Waterfall or Stock chart > Waterfall.
You can also use the All Charts tab in Recommended Charts to create a waterfall chart.
Tip:Use the Design and Format tabs to customize the look of your chart. If you don't see these tabs, click anywhere in the waterfall chart to add the Chart Tools to the ribbon.
Start subtotals or totals from the horizontal axis
If your data includes values that are considered Subtotals or Totals, such as Net Income, you can set those values so they start on the horizontal axis at zero and don't "float".
-
Double-click a data point to open the Format Data Point task pane, and check the Set as total box.
Note:If you single-click the column, you'll select the data series and not the data point.
To make the column "float" again, uncheck the Set as total box.
Tip:You can also set totals by right-clicking on a data point and picking Set as Total from the shortcut menu.
Show or hide connector lines
Connector lines connect the end of each column to the beginning of the next column, helping show the flow of the data in the chart.
-
To hide the connector lines, right-click a data series to open the Format Data Series task pane, and uncheck the Show connector lines box.
To show the lines again, check the Show connector lines box.
Tip:The chart legend groups the different types of data points in the chart: Increase, Decrease, and Total. Clicking a legend entry highlights all the columns that make up that group on the chart.
Here's how you create a waterfall chart in Excel for Mac:
-
Select your data.
-
On the Insert tab on the ribbon, click
(Waterfall icon) and select Waterfall. Note:Use the Chart Design and Format tabs to customize the look of your chart. If you don't see these tabs, click anywhere in the Waterfall chart to display them on the ribbon.
(Waterfall icon) and select Waterfall.
FAQs
Create a waterfall chart - Microsoft Support? ›
On the Insert tab, click SmartArt. In the Choose a SmartArt Graphic dialog box, on the left, select the Process category. Single-click a flow chart in the middle pane to see its name and description in the right pane of the dialog box. Select the flow chart you want, and then click OK.
Is there a flow chart template in PowerPoint? ›On the Insert tab, click SmartArt. In the Choose a SmartArt Graphic dialog box, on the left, select the Process category. Single-click a flow chart in the middle pane to see its name and description in the right pane of the dialog box. Select the flow chart you want, and then click OK.
Is there a flow chart in PowerPoint? ›Go to Insert > Shapes. Doing this opens a dropdown menu of PowerPoint's shape libraries—scroll down until you find the flowchart section.
How to do a waterfall chart in Excel 365? ›Select your data. Click Insert > Insert Waterfall or Stock chart > Waterfall. You can also use the All Charts tab in Recommended Charts to create a waterfall chart.
Is a waterfall chart the same as a Gantt chart? ›The waterfall methodology is often visualized in the form of a flow chart or a Gantt chart. This methodology is called waterfall because each task cascades into the next step. In a Gantt chart, you can see the previous phase "fall" into the next phase.
What is Gantt vs waterfall chart? ›Gantt charts allow for detailed project scheduling, linking dependencies and organizing tasks and project phases. A Gantt chart works best on a fixed project plan. Waterfall development software lets executives and stakeholders see fixed costs and schedules.
How do you make a total waterfall chart? ›To designate a data point as a total or subtotal, double-click on that data point (in this case, the ending balance). In the Format Data Point pane, check the "Set as total" box. Now the chart will display that value as a total or subtotal instead of adding it to the other values.
Can you make your own waterfall? ›It involves using rock, which many homeowners have right in their own backyard (or can find readily elsewhere). Once these two structures are in place, you'll use a pump in the pond to keep water recirculating from the pond to the top of your waterfall, whence it can plunge back down to the pond.
Can you make a vertical waterfall chart in Excel? ›Select the range, then click on the UDT Tab. Next, select the Waterfall Chart icon, choose your style (horizontal or vertical), and click the icon. The add-in will calculate the subtotals, and you will get the result asap.
How do I create a step chart in PowerPoint? ›To create a simple chart from scratch in PowerPoint, click Insert > Chart and pick the chart you want. On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, click the arrows to scroll through the chart types. Select the type of chart that you want and then click OK.
How to create a Swimlane diagram in ppt? ›
- Step 1: Create a Table to Distinguish Categories. Insert a table via Insert > Table. ...
- Step 2: Label Categories in the Diagram. ...
- Step 3: Start Showing the Process using PowerPoint Shapes. ...
- Step 4: Format Your Swimlane Diagram. ...
- Step 5: Insert Flowlines to Indicate Steps.