Showing multiple months on a single graph

[emueller]

Thanks to some excellent help here, I have generated the data I need... now I'm having issues displaying it correctly.

My data to be graphed averages data for the month into six categories. I'd like to be able to create a bar graph that shows each month's data, but shows each month on a single graph.

Currently, there is an individual graph for each month, and only by moving to the next record does the next month's data display.

 

[dhookom]

Is this a form or report? If it is a form, what's the form's record source?

Duane
Hook'D on Access
MS Access MVP

 

[emueller]

This will be on a form, which uses a query that generates a summarized [Month] (such as 2009-05) and the six points of data [ATDays1], [ATDays2] ... [ATDays6].

 

[dhookom]

Can we assume your link master child for the chart control is the month? If you want to see multiple months/charts, you will need a continuous form.

Have you considered use a report to display the charts?

Duane
Hook'D on Access
MS Access MVP

 

[emueller]

After removing the master child month from the setup, I got the result I wanted.

I haven't tried using a report to display the charts, and didn't even know it was possible.

 

[dhookom]

Charts on reports are not much different from charts on forms. You can generally copy from one to the other.

Duane
Hook'D on Access
MS Access MVP