Make a Cumulative Chart

This post will guide you how to make a cumulative sum chart in Excel. How do I create a cumulative sum chart in Excel 2013/2016. How to add a cumulative total to a line chart in Excel.

Create a Cumulative Chart


Assuming that you have a list of data in range B1:C5 that contain sales data. And you want to create a cumulative sum chart for these data. How to achieve it. You just need to do the following steps:

#1 select one blank cell next to the Sales column, and type the name of column D header as “TOTAL”.

make cumulative chart1

#2 type the following formula based on the SUM function in the Cell D2. And press Enter key in your keyboard, and then drag the AutoFill Handle from Cell D2 to D5.

=SUM(C$2:C2)

make cumulative chart2

#3 select all data, and then go to INSERT tab, click Insert Column Chart command under Charts group. And select one 2-D Clustered Column. And one Column Chart has been created based on the selected data.

make cumulative chart3

#4 click Total Data series in the chart, and right click on it and select Change Series Chart Type from the popup menu list. The Change Chart Type dialog will open.

make cumulative chart4

#5 change the Chart type for TOTAL data series to Line, click OK button.

make cumulative chart5

#6 select the line data series, and right click on it. And select Add Data Labels, then select Add Data Labels sub menu.

make cumulative chart6

#7 Let’s see the result.

make cumulative chart7

Related Functions


  • Excel SUM function
    The Excel SUM function will adds all numbers in a range of cells and returns the sum of these values. You can add individual values, cell references or ranges in excel.The syntax of the SUM function is as below:= SUM(number1,[number2],…)…
Related Posts

If Cell Contain Specific Text

This article will explain how to check if a cell contains text or a specific text string in Google Sheets or Microsoft Excel spreadsheets. In our daily work, we often look for specific text in worksheets containing large amounts of ...

Free Family Budget Template (Step-by-step Guide)

This article will show you some free printable family budget templates for google sheet and Microsoft Excel spreadsheet applications and will also explain some of the features or important functions of these templates. This will make it easy for you ...

6 Best Free Wedding Budget Templates

This post will show you some free wedding budget spreadsheet templates for both google sheets and Microsoft Excel Spreadsheet, as well as some explanations of the features or important function points of these templates. You can then easily make modifications ...

Calculate Cumulative Totals with Excel SUM Function

Today, through a simple example, we will show you how to use one of the most common-used Mathematical functions in excel, the SUM function, to add up the sum. In our daily life, we keep an account of what we ...

Check Dates in chronological order

Assume you have a date list that has different date formats, as seen in the accompanying picture. In this instance, Excel's Sort function will fail to sort them appropriately. However, you may convert all various date formats to a particular ...

Sidebar