Generating data for graphs

I'm knocking up a spreadsheet that deals with expense claims for a small company.

Under the Reason column you pick an expense type from a drop down list. What I'd like to be able to do is to set up a graph or table that can identify how much is spent on the different things. As there is a drop down menu system I'd like the worksheet to be able to differentiate the expense types and generate a total balance for each.

Enclosed is an example of the spreadsheet. With god's help I won't get a swift reply from Daffy Duck