# Help with cumulative sum graph

#### Umeboshi

##### New Member
Hi. I'm trying to create a bar and line graph displaying cumulative sums over time. Here is an example. Imagine you have three shops with respective sales over 12 months.
Jan Feb Mar Apr etc
Shop 1: 23 25 20 18
Shop 2: 14 12 12 15
Shop 3: 12 20 22 22

From here I can make a bar graph showing sales per month per shop, that's easy. With months on X-axis, each month would have three bars, one for each shop.
Now on top on that I need lines showing cumulative sales for each shop over time. For each month, that would be current month plus sum of all prefious months. It would have three lines (one for each shop and using same colors as the bars). In example above, the line for shop 1 would have data points 23 (Jan), 48 (Feb) 68 (Mar) and 86 (Apr) and so on. Similarly for other two shops. How can I do this on Excel 2010? I have been able to do it for a single shop, but can't make for more than one. Any help, thanks.

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Hi Umboshi,

Here are a few samples of what you are trying to do and how you should set up your data.

Things to note,
1) the cumulative information has been sent to the 2nd axis.
2) The 1st Axis maximum has been fixed to equal the height of the 2nd axis
3) On Jan-Apr series, I changed the series overlap = 100% on the series options dialog box

Let me know if this helps.

Steve=True

Replies
3
Views
56
Replies
1
Views
317
Replies
0
Views
158
Replies
3
Views
134
Replies
2
Views
157

1,196,343
Messages
6,014,726
Members
441,841
Latest member
Prabu_sanku

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back