How to make a cumulative sum chart in Excel?

If there is a list of data about monthly sale volumes in a year, and now you want to make a cumulative sum chart about it for others to view the cumulative sum of the sale volumes in every month clearly as following screenshot shown, how could you do? Here, I will introduce the way to make a cumulative sum chart in Excel.

Create an accumulative sum chart in Excel

Save and reuse the chart anywhere next time with Kutools for Excel

doc-create-cumulative-sum-chart1


Create an accumulative sum chart in Excel

1. Select a blank cell adjacent to the Sale column, in this case, select Cell C2, and type this formula =SUM(B$2:B2),  and then drag the fill handle down to the cells you want to apply this formula. See screenshot:

2. Then, select the data range and click Insert > Column > Clustered Column, see screenshot:

3. In the inserted chart, click one total column and right click to select Change Series Chart Type… from the context menu. See screenshot:

4. In the Change Chart Type dialog, click Combo from the left pane, and then select Clustered Column-Line chart type in the right pane, see screenshot:

Note: If you are using Excel 2010 and earlier version, please select Line in the left pane, and then choose one line chart type from the right pane, see screenshot:

5. Click OK, and then right click the line in the chart, and select Add Data Labels from the context menu. See screenshot:

6. Then you can see the cumulative sum chart has been finished:


Save and reuse the chart anywhere next time with Kutools for Excel

If you want to save this chart and reuse it next time anywhere of a workbook, you can apply the Auto Text tool of Kutools for Excel, it can help you save the chart quickly and reuse it as soon as possible.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. 

After installing Kutools for Excel, please do as follows:

1. Select the created chart, and then click Kutools > Navigation > Auto Text, see screenshot:

2. Then click button, in the New Auto Text box, please enter the name and choose the group to your need, and then click Add button. See screenshot:

3. And the chart has been inserted into the Auto Text pane, when you want to insert it to anywhere, please click Insert to insert the chart, see screenshot:

4. Then you should apply the new data into the chart as you need, please selec the chart, and then click Design > Select Data, see screenshot:

5. In the Select Data Source dialog box, please click button to select the new data you want to applied to the chart, see screenshot:

6. Then click OK button, the new data will be applied to the cumulative sum chart, see screesnhot:

Download and free trial Kutools for Excel Now !


Demo: Create an accumulative sum chart and reuse it anywhere next time

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Relative Articles:

Make a cumulative average chart in Excel


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Mostafiz, Dhaka, BD. · 3 years ago
    MS Excel calculation of horizontal cumulative sum problem.
  • To post as a guest, your comment is unpublished.
    Mostafiz, Dhaka, BD. · 3 years ago
    I need horizontal cumulative sum of a series of values of 12 months in a row and in side by side cell. how? is it possible? I could send you a work sheet but can't. there is no option in this page and i have no email address of you. pls solve my problem and provide me your e-mail as i can send you the excel work sheet.

    Best regards,

    Mostafiz
    Dhaka, Bangladesh.
  • To post as a guest, your comment is unpublished.
    Dada · 4 years ago
    How do you aggregate data in excel 2016
  • To post as a guest, your comment is unpublished.
    khalid · 5 years ago
    Great, Very helpful and easy to understad
  • To post as a guest, your comment is unpublished.
    MV · 5 years ago
    thank you very much! It saved my day.
  • To post as a guest, your comment is unpublished.
    Rin · 5 years ago
    very helpful and straighforward.
    Thank you.
  • To post as a guest, your comment is unpublished.
    harendra · 5 years ago
    i want to calculate a running sum.i dont know how to do it in excel.plzzz help me out!!!!!
    for eg:-
    no sum
    6 6
    then when i enter some other values in no column then it should be added to the current value of sum i.e

    no sum
    3 9 (as previous 6 + 3 =9 )
  • To post as a guest, your comment is unpublished.
    steve liu · 5 years ago
    sorry, I used b$2,b2 instead of b$2:b2
  • To post as a guest, your comment is unpublished.
    steve liu · 5 years ago
    I tried your example but it's working a bit strange. The first cell (c2) would add B2 to B2 (resulting in 6262 instead of 3131). All the other cells work right. Can you suggest what I can try to fix it? Thanks!