Charts on reports (1 Viewer)

[Pastor Del]

Can someone show me what I'm doing wrong with the chart in the attached DB? I need just one chart for each team but I'm getting 5 times as many charts as I want.

I'm using Access 2010 on Windows 7 & Vista

 

[JHB]

Is it so you want it, see below picture, (the database is attached)
Choose "Print Preview" when you open the report.

 

[Pastor Del]

This is great. The way I managed to do it required 10 charts because there are 10 teams that will be charted. One down side to my way is that I need to modify the report design if another team is added to the list. Yours is much better. Can you provide me with a step by step instruction of how to do this. Unfortunately I have very little experience with charts.

 

[JHB]

... Can you provide me with a step by step instruction of how to do this. Unfortunately I have very little experience with charts.

The basic behind it is the same as when you create sub forms and sub reports, the Master-/Child field linking.