With our Special Charts feature, you can easily create Waterfalls, Stacked Waterfalls, and Marimekko charts in one click.
Create Waterfall and Stacked Waterfall charts
A Waterfall chart (or Bridge) is an intuitive tool to visualize the cumulative effect of sequentially introduced positive or negative values.
To create a Waterfall chart, simply:
- Select the range of data
- Click the Charts drop-down in the UpSlide ribbon
- Click Waterfall (or press CTRL+Shift+B)
- If you update the data, the waterfall chart will update directly. If you insert or delete data, you will have to reassign the source by selecting the chart, clicking the Charts drop-down, and clicking Select Source Data
As shown the chart is responsive to changes in values and correctly displays when the overall measure (in this case EBITDA) drops below 0.
To create a Stacked Waterfall chart, repeat the steps above, but click Stacked Waterfall in the Charts drop-down.
Organizing your source data
In the example data are organized in columns. UpSlide can also generate a Waterfall if your data is organized horizontally. For Stacked Waterfall charts, all data in the same row must be of the same sign.
The first and last rows of the source table are always treated as results (not effects). If your data contains one or more intermediary results, UpSlide will automatically detect it and use the appropriate column to represent it in the Waterfall.
You can add multiple levels of depth on the X-axis to have headings to your x-axis labels. Add them via the native edit horizontal category axis label option. See below:
Create Marimekko charts
Marimekko charts are 100%, stacked column charts where the bar width reflects an additional variable.
To create this kind of chart, we recommend using the Examples button in the Charts drop-down. With this feature, you can preview different chart types and insert sample data into a new sheet.
After adding an example Marimekko chart, you can add rows or columns of data in the sample if you want more values for your variables. UpSlide also proposes a variant, the S-curve, which differs from the standard Marimekko chart because of the absence of data normalization, meaning data is no longer presented as a percentage.