I'm hoping the RevCounter's excel gurus have made it over here.
If I have a spreadsheet like this:
Is there an easy way to have line style chart that displays the week by week running total? So the first line would go from 10 to 12 to 13 and down to 8 and so on.
Thanks.
Excel help  Charts

 Posts: 330
 Joined: Sun May 03, 2020 10:11 pm
 Has thanked: 30 times
 Been thanked: 170 times
Re: Excel help  Charts
Make a row with that sum in it. Select that row and the Week row and insert chart.
Then format it as every choice of chart type until you accidentally find one that looks right.
Then format it as every choice of chart type until you accidentally find one that looks right.

 Posts: 1512
 Joined: Mon Mar 16, 2020 7:57 pm
 Location: Milton Keynes
 Has thanked: 429 times
 Been thanked: 848 times
Re: Excel help  Charts
Create another row at the bottom with the running total. You can get excel to calculate that bit by just adding the two relevant cells together.
You the want an XY scatter plot* with the week numbers as the X field and the newly calculated running total as the Y.
I would probably create a second new row with your week numbers (0, 1, 2 etc rather than "Week 1") because Excel will cope with that in a much more intuitive way. If you can get it to sensibly work with dates and they produce a graph with 'em you're a smarter man than I
*IME you pretty much always want an XY scatter plot, all the others are crap. Except maybe pie.
You the want an XY scatter plot* with the week numbers as the X field and the newly calculated running total as the Y.
I would probably create a second new row with your week numbers (0, 1, 2 etc rather than "Week 1") because Excel will cope with that in a much more intuitive way. If you can get it to sensibly work with dates and they produce a graph with 'em you're a smarter man than I
*IME you pretty much always want an XY scatter plot, all the others are crap. Except maybe pie.
Re: Excel help  Charts
I want each row to have it's own line on the chart and there's going to be 20 of them.Mr. Dazzle wrote: ↑Fri Sep 04, 2020 10:50 pm Create another row at the bottom with the running total. You can get excel to calculate that bit by just adding the two relevant cells together.
You the want an XY scatter plot* with the week numbers as the X field and the newly calculated running total as the Y.
I would probably create a second new row with your week numbers (0, 1, 2 etc rather than "Week 1") because Excel will cope with that in a much more intuitive way. If you can get it to sensibly work with dates and they produce a graph with 'em you're a smarter man than I
*IME you pretty much always want an XY scatter plot, all the others are crap. Except maybe pie.
But from what you both say I can create a bunch of row that give the sums and make a chart from those.