Need help with implementing chart in a subreport

[MatthewsP]

I have a subreport that I want to show as a graph. The source is a crosstab query that returns data looking like the following:

ScenarioID Type Q1 Q2 Q3 Q4
--------------------------------------------------------
1 Required # # # #
1 Unused # # # #
1 Incremental # # # #
2 Required # # # #
2 Unused # # # #
2 Incremental # # # #
3 Required # # # #
3 Unused # # # #
3 Incremental # # # #

(Scenario ID and Type are row headings, Q1-Q4 are the values for the columns.)

For each ScenarioID, I want to be able to show a side-by-side bar chart that shows the Required, Unused, and Incremental values for each quarter.

The master report has one record for each ScenarioID.

Any assistance appreciated!