Calculating Chart Values over large Ranges with catagories

I am working on a custom log file for my company. It has 3 sheets and on each sheet is a service type column with drop downs and next to it an amount coumn. Every day that a service issue is requested someone goes in and chooses the service type from the drop down and enters the amount in USD.

I want to add charts to the top of each sheet and on the axis i want to have service type and then the total amount spent on that catagory

I cant figure out how i would do this and would GREATLY appreicate any help!!

thanks,

Sean