Help with cumulative sum graph

[Umeboshi]

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.

 

[Steve=True]

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