I would like to create a report that has multiple charts. Preferably two per page. I would like line charts. I can create one of these charts using the Chart Wizard, but I can't figure out how to add additional charts. There are going to be 221 charts in total, so automating it is a must.

The source query I am using to create the chart with the Wizard is:



Code:
SELECT KWB_Raw.Well, (Year([Date])) AS SampleDate, KWB_Raw.Observed, KWB_Raw.Simulated, KWB_Raw.ChartOrder
FROM KWB_Raw;
WHERE ChartOrder = 1
I want the next chart to contain the same data only 'ChartOrder' will be equal to 3, etc etc. The Wizard is also summarizing 'Simulated' and 'Observed' as the Max of each. I'm guessing the SQL statement will need to have a variable that increments +1 each cycle to get the ChartOrder to continue to increase.

Someone save me!