Charting data that needs to be consolidated?

Using Excel 2007:


Say I have a list of sales by employee. Employees can have more than one sale, so eache mployee might have 2 or maybe even 5 sales in a month. When I try to chart this information I only want each employee listed once. So the sales need to be consolidated. I made a subtotal for each employee but the charting functions do not work at all. I've tried all kinds of combinations for input data.

Here is a sample of the data. (names are not real)

Sales Rep Name	Sales Date	Sales Amount	Commission
Brady Anderson	6/15/2010	$2,500.00 	$187.50 
Brady Anderson	6/12/2010	$2,200.00 	$165.00 
David Green	6/12/2010	$1,900.00 	$142.50 
David Green	6/15/2010	$1,800.00 	$135.00 
Richard Taylor	6/17/2010	$2,525.00 	$189.38 
Richard Taylor	6/15/2010	$2,300.00 	$172.50 
Richard Taylor	6/17/2010	$1,775.00 	$133.13 
Tasha Johnson	6/19/2010	$1,875.00 	$140.63 
Tasha Johnson	6/17/2010	$1,825.00 	$136.88 
Tasha Johnson	6/22/2010	$1,790.00 	$134.25 
Tasha Johnson	6/15/2010	$1,750.00 	$131.25 
Tasha Johnson	6/14/2010	$1,750.00 	$131.25 
Tasha Johnson	6/12/2010	$1,450.00 	$108.75 
Violet Newhouse	6/22/2010	$1,875.00 	$140.63 
Violet Newhouse	6/18/2010	$1,950.00 	$146.25 
Violet Newhouse	6/17/2010	$1,875.00 	$140.63 
Violet Newhouse	6/12/2010	$1,875.00 	$140.63