Excel 2007 : Charting Time Sheets - is this possible?

I need to create a database with about 250 time entries, the entries are like this:

Date, User, Activity Description, Activity Type, Time

2/5/11, Jane, Read Email from Mark, Email, .1
2/6/11, Mark, Create email to Jane, Email, .2
2/7/11, Jane, Review spreadsheet, Review, .5
2/7/11, Mark, Review spreadsheet, Review, .5


Is it possible to then chart that data to show the following:

1 chart which shows how much time Jane spent versus how much time Mark spent on ALL activities so it would show 50% Jane and 50% Mark

1 chart which shows how much time was spent on email activity versus review activity so it would show .3 portion of time for email and 1.0 portion of time for review

and perhaps a bar chart showing activity per day for all users ?

Thank you very much I will explore those

Originally Posted by delforum

It appears you are in need of some Pivot Tables. This will combine all the similar activities and dates and names to one line...totaling the hours. Then you can sort with the autofilter items at the top of the list. Normal charts can be created from this Pivot Table.

Here is an example of how you can bring things together. On Sheet 4 I created a pivot chart, by the insert menu....and just dragged your columns into the template. See the attachment.

Thank you very much I'm playing with it now, it looks like exactly what I need