Charts in Report repeating

[WineSnob]

I am very new to charts/graphs in Access. I was able to create the chart data using a query and was able to create the chart in a report (it is correct). However the charts repeats itself 12 times. I am sure it is because the query returns 12 lines of data. It is a chart of Sales by month (12) each chart is identical. All I need is one chart one page. I do not have group by on the query. Where do I look for the problem? Thanks.

 

[AccessMSSQL]

Check the recordsource of the form or report you are displaying your chart in. If you have the chart in the detail section of the report and the report source set to the 12 month query, then it will repeat 12 times.

 

[WineSnob]

:banghead: OF COURSE ! I guess I was overthinking it !!!!! :banghead: