With our Special Charts feature, you can easily create Waterfalls, Stacked Waterfalls, and Marimekko charts in one click.
Create 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:
- Select the range of data
- Click the Charts dropdown 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.
Create Stacked Waterfall charts
A Stacked Waterfall chart adds nuance to a standard Waterfall chart displaying each effect broken out by subcategory. To create a Stacked Waterfall:
- Select the range of data.
- Click the Charts dropdown in the UpSlide ribbon.
- Click Stacked Waterfall.
Now that your chart is generated, you can use the options menu on the top right corner to stack or unstack pillar variations according to your preferences.
Default settings for Stack pillars and Stack variations options can be set at account level but overridden at user level.
If you update the data values, the chart will update directly. If you insert or delete rows or columns, you will have to reassign the source by selecting the chart and clicking Select Source Data in the Charts dropdown menu.
Organizing your source data
In the example, data are organized in columns. UpSlide can also generate a Waterfall if your data is organized horizontally.
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.
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.