Posted March 01, 2018 05:21:22You may have noticed that PowerPoint doesn’t have a waterfall chart, but that’s because the tool doesn’t support it.
Excel is capable of rendering a chart when a user clicks on a link, but you can’t click on a slide instead of a link.
That’s because PowerPoint uses an embedding feature to embed the chart, so it doesn’t need to embed anything in order to display the chart.
But when a link is clicked on, it renders the chart instead of the link.
This article walks you through how to use a waterfallchart in PowerPoint.
In this case, the link is a slide showing a list of the top 10 largest U.S. cities, and the chart is a horizontal bar.
This means that the text in the bar can be read by any user.
So you can type in a user’s name and see what their favorite city is.
The most important thing to remember about this chart is that the number of cities in the chart will increase with each click.
That means the bars on either side will increase to show the percentage of each city that’s larger than or equal to the other.
In the case of this chart, the number in the center of each bar represents how many cities the user is most likely to be interested in.
In other words, if the bar on the left is a 10, the right one is a 0.
The more cities in a row, the more likely that user is to be a fan of that city.
The table below shows the formula for the waterfall chart.
For example, the formula would be:The table also shows that the chart doesn’t change with the number and size of the cities in it.
So the chart can be rendered with a small number of bars and a large number of columns.
Here’s how the chart would look if the table had been set to 100% (or the text “100%” instead of “50%”):You’ll notice that this chart looks much better when there are a lot of bars in the row.
In fact, this chart can look like this:The waterfallchart is especially useful when you’re building out a presentation.
Here’s a sample slide that shows how to do that in PowerPoint:You can also use the waterfallchart to display other data like traffic numbers.
The table below lists the formulas for a simple waterfallchart that would display the number on each line.
This would be a waterfall-chart-generated presentation:You’ll note that the table has an additional column that shows the number for each of the lines in the presentation.
In this case the number is calculated as a fraction of the line’s length.
Here are some other examples of waterfall charts you might find useful.