Task Tracker Spreadsheet

Hey everyone!

I'm trying to create a task tracking application thats pretty simple.

Here is a sample of data that I would enter into Excel.

Date Description Category Time(mins)
1/1/2011 Fixed computer Maintenance 60
1/1/2011 Purchased Ink Purchase 60
1/1/2011 Helped staff with email Support 15
1/2/2011 Fixed laptop Maintenance 35
1/2/2011 Fixed server Maintenance 45
1/3/2011 Training Training 180
1/3/2011 Setup projector Support 5

Now I know how to make basic graphs, but my problem is this. How can I create a bar graph that will sum up all the categories and the total time for each?

Hello!

Thank you so very much. This is exactly what I was looking for.

Thanks for your time.