I have a table containing around 25,000 records. I would like to create multiple charts from the records in this table. Rather than group everything together (which Access is doing by default via Chart Wizard) I would like each chart broken down by the 'ID' field. So if I have 25 records with the ID of '1' I want to create a chart using the data matching ID '1'. If I have 6 records with the ID of '2', create another chart using the data matching ID '2'. Etc. How can I do this?

So, in a nutshell, for each ID I want to create a chart