How to Create Chart to Show Cumulative Sum (Running Total)

In this Note, we'll show you how you can create a chart to show the Cumulative Sum (Running Total) with 'Window Calculation' feature.

Sample Data

We'll use this Unicorn (private startups that are valued more than $1billion) data. (Download link).

In this data, each row represents each unicorn company, and the columns are companies' attribute information.

Create the Chart

The goal is to create a bar chart that shows the cummulative number of unicorn companies by Date and by Country.

1. Create a Bar Chart

First, create a bar chart by selecting the followings.

  • X-Axis: Date Joined -> Month
  • Y-Axis: Number of Rows
  • Color: Country

2. Use Window Calculation to Show Percentage of Total

Now, it's time for 'Window Calculation'!

Click the 'Menu' icon next to the Y-Axis, select 'Quick Window Calc.', then select 'Cumulative Sum'.

And that's it, now you have a bar chart that shows the cummulative sum of unicorn companies by Date (Month) and by Country!

You can click on the Green Text to open the configuration dialog for more detail setting if you like.

Export Chart Image
Output Format
PNG SVG
Background
Set background transparent
Size
Width (Pixel)
Height (Pixel)
Pixel Ratio