chart on the group footer

[iccsi]

I want to have a chart for different group, so I put the cahrt on the
group footer to show the chart for the group.

Because the chart only shows one group, the row source need change
every time. I tried to use DAO.QueryDef to modify the query every time
on FooterFormat even.

It seems the the chart can only have one SQL statment on FooterFormat
Event.

If I am not on the right track, please advise me any other solutions.

Any information is great appreciated,

 

[Duane Hookom]

I expect you only need to set the Link Master/Child properties of the chart
control.

 

[inungh]

I expect you only need to set the Link Master/Child properties of the chart
control.
--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

Thanks for the message,

My query result is like following:

Group ID, type ID, week1, Week2, Week3, week4
1 1 90 80 85 60
1 2 30 40 20 50
2 1 20 30 40 10

I would like to have a chart to change group ID on the group footer
only for that group, but include all type ID in the same group.

if I set mater/child link for group ID then MS Access will show only
the chart the the group only that the query I link to?


Thanks again,

 

[inungh]

I expect you only need to set the Link Master/Child properties of the chart
control.
--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

Thanks millions for helping,
It works,
Can you please let me know does MS Access support column an series in
row and column?

My table is like following:

groupId, Type ID, week1, week2
1 1 80 50
1 2 30 20

It looks like MS Access need data like following:

Group Id, Type ID, Week ID, Value
1 1 1 80
1 1 2 50
1 2 1 30
1 2 2 20


Thanks in advance,







Thanks again,

 

[Duane Hookom]

I prefer to keep my data normalized. The chart generally likes it this way
also. You can always create a crosstab to un-normalize.

 

[inungh]

I prefer to keep my data normalized. The chart generally likes it this way
also. You can always create a crosstab to un-normalize.

--
Duane Hookom
Microsoft Access MVP












- Show quoted text -

Thanks again,
It seems that chart wants the x-axes on the first column and the one
series on one column.
It shows my child link field as a series, it does not have link if I
take the field out of the query.

Are there any way to keep master child link and without showing the
child link field on the chart?

Your help is great appreciated,

 

[Duane Hookom]

The linking field does not have to be displayed in the chart.

 

[inungh]

The linking field does not have to be displayed in the chart.

--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

That's what I tried to do, but it is always shows in the chart.
If I remove the child link field from my query then it lost the link.
I tried to figure what I did wrong.
Any suggestions?

Thanks again,

 

[Duane Hookom]

You might want to check the sample of the graph with two linking fields at
http://www.access.hookom.net/Samples.htm.