Charting % - Please Help

I made this nice little database, it has all kinds of user input. So then I try to chart the info I've gathered. access won't let me do what I want to, or, I don't know the right way to query the data.

What I have is (example):

Good Parts, Bad Parts, Date(by the week)

All I want is a chart to plot the good parts, and run a 2-axis for the percent, by the week.

When I run the chart wizard and drag the Good Parts over access turns it to SumOfGood Parts( I don't want that!) when I drag the percent over access turns it into SumOfPercent(i don't want that either). Or I get some crazy number for the %, eventhough I formatted the critera column.

Can someone please help. All I want is the quantity of good parts I queried, and the actual percent that I queried. Not SumOf....


Thanks

Dan