Excel help - Charts

User avatar
McNab
Posts: 45
Joined: Mon Mar 16, 2020 4:07 pm
Has thanked: 12 times
Been thanked: 17 times

Excel help - Charts

Post by McNab »

I'm hoping the RevCounter's excel gurus have made it over here.

If I have a spreadsheet like this:
sheet.PNG
sheet.PNG (4.86 KiB) Viewed 247 times
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.
JackyJoll
Posts: 330
Joined: Sun May 03, 2020 10:11 pm
Has thanked: 30 times
Been thanked: 170 times

Re: Excel help - Charts

Post by JackyJoll »

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.
Mr. Dazzle
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

Post by Mr. Dazzle »

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 X-Y 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 :D

*IME you pretty much always want an X-Y scatter plot, all the others are crap. Except maybe pie.
User avatar
McNab
Posts: 45
Joined: Mon Mar 16, 2020 4:07 pm
Has thanked: 12 times
Been thanked: 17 times

Re: Excel help - Charts

Post by McNab »

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 X-Y 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 :D

*IME you pretty much always want an X-Y scatter plot, all the others are crap. Except maybe pie.
I want each row to have it's own line on the chart and there's going to be 20 of them.
But from what you both say I can create a bunch of row that give the sums and make a chart from those.