creating and manipulating Charts on reports

[Crowley16]

I have a report bound to a query.

On this report, I have 2 groups, the output is something like:

[tt]Region[/tt]
[tt]nameA numOp1 numOp2 numNew[/tt]
[tt]nameB numOp1 numOp2 numNew[/tt]
[tt]nameC numOp1 numOp2 numNew[/tt]
[tt]..... ...... ...... ......[/tt]

There are upto 8 regions, each of which can contain any amount of names.
numOp1, numOp2 and numNew are all counts of occurences of values within fields.

Now, what I have been trying (and failing) to do is to make a graph below each region group that shows nameX on the x axis, and for each nameX to display 3 bars, 1 for sum(numOp1) 1 for sum(numOp2) and one for sum(numNew).
Something along the lines of:

[tt]7| [/tt]
[tt]6| [/tt]
[tt]5| | [/tt]
[tt]4| | | [/tt]
[tt]3| | | | | [/tt]
[tt]2| || | | || [/tt]
[tt]1|_|||____|||____|||___[/tt]
[tt]--name1 name2 name3 [/tt]

Also, at the end of the report I would like to put a graph similar to the one above, but this time, for the regions instead of names in each region.

I have been messing about with the chart wizzard and options for days now and am not getting ANYWHERE! So any help would be much appreciated. Or any links or guides for programically changing the chart options through vba would also be nice.

Thanks in advance

 

[dhookom]

I did this by creating a report with a row source of each unique Region (totals query). My graph control has a Row Source property of:
SELECT TheName, numOp1, numOp2, numNew FROM tblForGraph;
Set the Link Master/Child properties to Region.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Crowley16]

Yeah, that worked... but I've not set the links...

Thanks, if this took any longer to crack, then I'd probably be minus some hair...

p.s. I'd still like to know about how to do this programatically, if anyone's got any handy links. I'm really beginning to hate wizzards, especially chart!

 

[dhookom]

I rarely use wizards. The more complex the wizard, the more I don't like the results.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Crowley16]

yeah, I've noticed that...

normally I don't use wizzards at all...

However I can't seem to find any good guides on how to access and use the MSGraph module so I'm stuck with wizards, for the time being of course...