Negative waterfalls with positive values? empower® charts makes it possible!
Oct 22, 2018
Waterfall diagrams are often used to represent a temporal evolution. In empower® charts you have the option of viewing a waterfall diagram backwards. This function makes it possible to break down a sum into its individual components.
We illustrate the function using an example. You want to differentiate the expenditures of your company. You have a total of 1.000 Euro of expenditure. How does this amount come about? A waterfall diagram is well suited for the visual representation of this scenario. The sum is broken down into its individual components (A, B, C, D).
First insert a waterfall diagram into PowerPoint. Click on “Insert” and “empower Chart” and select “Waterfall”.
Now a prefabricated diagram is inserted.
To edit the contained data, click on “Data” in the action bar and open “Edit data”.
The Excel table of the diagram opens, here you can now enter the desired values and labeling. According to the above example, this looks as follows:
Place the positive values in the table; at the end the total is built with the special value x.
The diagram is now presented in the form of a temporal development.
Since you do not want to represent a temporal development, but parts of a sum, you should change the direction of the waterfall. This makes empower® charts possible with just one click. To do this, click on “Data” again. Then click on Waterfall Direction “Right to Left”.
The diagram is now displayed in descending order, starting from the sum. As already mentioned, this is practical whenever the composition of a sum is to be explained.