Adding charts to Excel (Excel 2010)

I have attached an example of a sheet I have to turn in each month. I have it color coded by week and would like to know how I can make a new sheet that shows a chart.
I would like to have the chart show the average for the week, the total count for the week, then the total count for the month and total average for the month.
I will also need to make a third sheet that would be broken down to each Agent 1 thru 8 with pretty much the same format of average for the week, then month.

I hope this request isn't a tall order. I've just never dealt with charts. I've only dealt with data.

Any help would be greatly appreciated.

Thanks.

Use the first row above your data table for column labels. Then you can easily create a pivot table or a pivot chart to summarize your data by any given time frame or parameter.

To get started with pivot tables, see http://peltiertech.com/Excel/Pivots/pivotstart.htm

See attached for a simple pivot chart on Sheet1. Use the week filter to display the data for a specific week.

Originally Posted by npamcpp

Use the first row above your data table for column labels. Then you can easily create a pivot table or a pivot chart to summarize your data by any given time frame or parameter.

To get started with pivot tables, see http://peltiertech.com/Excel/Pivots/pivotstart.htm

See attached for a simple pivot chart on Sheet1. Use the week filter to display the data for a specific week.

The first row on my sheet (not the example I provided) does include labels. The only info I need for the chart is the Agent name and their average (per week and per month), not the other columns.

Thank you for the links. I'll see what I can come up with.