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.
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.
It's because the charts are in Detail section. Just like any control in Detail section, it is repeated for each record. Move charts into Report or Group header or footer section. Move the label controls from Page header to Report header, turn off Page section, tighten up spacing between graphs, all should fit on one sheet.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.