Chart report to show sum question

[SwingXH]

I have a table as below:

JobID Name Hours DueDate
1 AAA 10 June 6, 2004
2 BBB 50 July 6, 2004
3 CCC 100 April 20, 2004
4 AAA 20 May 30, 2004
5 BBB 40 Aug 30, 2004

I want to creat a chart report that shows the number of jobs that each individual worked in certain time period and also show the sum of the total jobs on the same chart.
I was able to make a chart using wizard to show # of jobs that each person worked, for example AAA has 2, BBB has 2 and CCC has 1. but I don't know how to make the total which is 5 on the chart. ANbody can help me?

Also I would like to the user can select the time range, for example between May 01 and Septem 1, 2004 for this chart.

Thanks a lot!

SwingXH