Then you can see the cumulative sum chart has been finished: Click OK, and then right click the line in the chart, and select Add Data Labels > Add Data Labels from the context menu. 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:ĥ. 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: In the inserted chart, click one total column and right click to select Change Series Chart Type… from the context menu. Then, select the Target and Total column ranges, and then click Insert > Column > Clustered Column, see screenshot:ģ. Select a blank cell adjacent to the Target 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. 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 some ways to make a cumulative sum chart in Excel.Ĭreate an accumulative sum chart in ExcelĪdd accumulative sum for chart in Excel with a handy featureġ. How to make a cumulative sum chart in Excel?
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |