Table of Contents
Creating a Cumulative Sum Chart in Google Sheets is a simple and effective way to visualize the cumulative total of a series of data points. To create this chart, simply enter your data points in a column or row, then select the range of cells. Next, go to the “Insert” tab and choose “Chart” from the drop-down menu. In the “Chart Editor,” select “Cumulative sum” under the “Chart type” section. Finally, customize your chart by adding titles, labels, and formatting options. This chart is useful for tracking the overall progress or growth of data over time.
Create a Cumulative Sum Chart in Google Sheets
This tutorial provides a step-by-step example of how to create the following cumulative sum chart in Google Sheets:
Let’s jump in!
Step 1: Enter the Data
First, let’s create the following dataset that shows the total sales of some item during each month in a year:
Step 2: Calculate the Cumulative Sum
Next, we’ll use the following formula to calculate the cumulative sum of sales:
=SUM($B$2:B2)
We can type this formula into cell C2 and then drag and fill it to every remaining cell in column C:
Step 3: Create Cumulative Sum Chart
Next, highlight the cell range A1:C13, then click the Insert tab along the top ribbon, then click Chart.
In the Chart editor panel, click the Setup tab, then choose the chart titled Combo chart:
The following chart will appear:
The blue bars represent the sales each month and the red line represents the cumulative sales.
Feel free to customize the title, customize the colors, customize the line style, and adjust the width of the bars to make the plot look however you’d like.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I create a Cumulative Sum Chart in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-cumulative-sum-chart-in-google-sheets/
stats writer. "How can I create a Cumulative Sum Chart in Google Sheets?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-cumulative-sum-chart-in-google-sheets/.
stats writer. "How can I create a Cumulative Sum Chart in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-cumulative-sum-chart-in-google-sheets/.
stats writer (2024) 'How can I create a Cumulative Sum Chart in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-cumulative-sum-chart-in-google-sheets/.
[1] stats writer, "How can I create a Cumulative Sum Chart in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I create a Cumulative Sum Chart in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.