Need a report to display how many entries each group from each site has entered into a list

Question

Okay, I know that this is going to be super-easy for you guys, and that you will think I'm a complete noob (which I am), but I need a friggin chart in Sharepoint (or even Excel), and can't wrap my head around how to get it done. 

I have several sites, from which several users belonging to several groups enter shift log entries.   The list columns are:

• Title - Single Line of Text
• Log Entry - Memo
• Site - Choice
• Group - Choice

How would one go about producing a chart on this data?  Bar graph, or pie chart equally satisfying in this case. 

Answer 1

This is what I did to produce the report.  I created an access database of the list, and built a query with the Site & Group fields.   I saved the database back to the Sharepoint site in a document library.  I then created an excel spreadsheet that used an Access Database datasource (the one saved to the site) and used PowerPivot within excel to build the charts. 

I uploaded the spreadsheet to the library as well and then I added the Excel Web Access Web part to a page called Charts on the site.  Of course, now I'm having issues with refreshing the data due to Claims to Windows Token Service (c2wts) not being able to delegate credentials.

But that's another story.