Adding A Total Column To A Waterfall Chart In Think-Cell

New Product Launch - The Business Strategy & Consulting Toolkit

Your personal repository of 152+ pre-built and client-ready slides for strategy projects (value proposition, go-to-market, organizational design). Don't waste time building slides from scratch. Learn more...

In this tutorial, we’re going to show you two simple ways to add a total column to a waterfall chart in think-cell.

Method 1: Type ‘e’ in your waterfall chart dataset

In the image above, you can see a total column for ‘FY20 Cash Earnings’ with a value of 7. This type of total column is connected to the rest of the waterfall chart.

To add a total column like this, simply type e in your datasheet (see row 8 in the image above). The letter ‘e’ stands for equals, and this will add a new column that stretches down to the baseline of the chart.

Method 2: Add a new column and delete the connector

In the image above, you can a different type of total column called ‘FY20 Competitor Cash Earnings’. As you can see, this total column is not connected to the rest of the waterfall chart.

To add a total column like this, add a new segment in the data sheet. By default, this segment will initially appear as an upwards facing segment in your waterfall chart.

Then navigate back to the chart, left-click on the connector associated with this new column, and press delete. The segment will turn into a standard total column.

Best Selling Courses, Toolkits and Templates

Trusted by thousands of executives, consultants, and freelancers

Template Pack

Templates, Elements, Graphics & Icons Pack

537 Shapes, Graphics and Icons
$29
Course

Executive Communication and Storytelling with PowerPoint

20 Lessons | 1.5 Hours of Content
$199
Course

Business Strategy & Consulting Toolkit

152 PowerPoint Slides | 39 Frameworks | 7 Excel Models
$249