Excel help

[Crackle]

I used to do this but I've forgotten how...

I've downloaded my bank statement and on the end added a column to categorise spending. So I can add a filter and just see how much I've spent on beer and carrot cake by sub-total.

What I want to do next is a simple graph of each category and the total spend in it. What I'm sure i used to do was pick the category column and the spend column and then it would sum it by category but this no longer works as I remember and I can't figure it: Help!

 

[psmiffy]

type pivot graph in the help box - its pretty self explanatory after that

edit - best if everything is in columns and has a value

 

[Crackle]

type pivot graph in the help box - its pretty self explanatory after that

edit - best if everything is in columns and has a value

I knew someone would say pivot tables. I'm damn sure I never used them before but I shall go and read the tedious excel help instructions

 

[psmiffy]

best I could do on a slow connection

 

[psmiffy]

In triplicate it seems

 

[psmiffy]

best I could do on a slow connection

View attachment 358904 View attachment 358904 View attachment 358904

 

[Crackle]

best I could do on a slow connection

View attachment 358904 View attachment 358904 View attachment 358904

You've even got the relative quantities right!

Tah, I've done it, even though I still haven't actually got my head around how I did it

 

[Crackle]

OK, not quite done it, unless I spent more on dog biscuits than I earned: Goes off to scratch head.......

 

[Crackle]

OK, I get it. Blank rows.

 

[Crackle]

Cheers Smiffy, I've completely got it now, in fact my mind is reeling from the cost of dog biscuits.

 

[psmiffy]

you have to fiddle with the properties in the right hand panel - as default it normally counts rather than sums the items

you don't really need to know how - manly just drag and drop

 

[Crackle]

you have to fiddle with the properties in the right hand panel - as default it normally counts rather than sums the items

you don't really need to know how - manly just drag and drop

View attachment 358906

Yeah I changed it to sum from count. I'm just tidying it up now.

 

[Markymark]

Pivot tables or sumif if you can't be bothered.

 

[psmiffy]

Pivot tables or sumif if you can't be bothered.

sumif is a Lundun fing innit

 

[Markymark]

sumif is a Lundun fing innit

General rule...if it's awesome it's London.