Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Charts - How to create new Graph for each Series

Status
Not open for further replies.

air0jmb

Technical User
Sep 8, 2006
38
US
My query [qryIssue6_3MoRates] has 3 fields: CalMonth, Issue, 3MoRate. There is 360 records - 24 Months x 15 Issues, with the 3MoRate value for each.

qryIssue6:
SELECT qryIssue4.CalMonth, qryIssue4.Issue, IIf(Sum([qryIssue4_1].[SRD])=0,0,Sum([qryIssue4_1].[Ex])/Sum([qryIssue4_1].[SRD])*100) AS 3MoRate
FROM qryIssue4 INNER JOIN qryIssue4 AS qryIssue4_1 ON qryIssue4.Issue = qryIssue4_1.Issue
WHERE (((qryIssue4_1.CalMonth)>DateAdd("m",-3,[qryIssue4].[CalMonth]) And (qryIssue4_1.CalMonth)<=[qryIssue4].[CalMonth]) AND ((qryIssue4.CalMonth)>=#11/1/2004# And (qryIssue4.CalMonth)<=#10/31/2006#))
GROUP BY qryIssue4.CalMonth, qryIssue4.Issue
HAVING (((Count(qryIssue4_1.CalMonth))>2));

I want the report to show 15 line graphs - 1 graph for each of 15 Issues. Each graph would show 3MoRates over 24 months.

Everything I try ends up with 1 or 15 graphs that each have 15 points (in the same series) for each month. I also tried setting both the report record source and the graph record source to the query, creating a grouping header for Issue, and linking parent and child fields to Issue. I have another graph where this works, but when I do same for this one the graphs show up empty (the border is there, but no axis labels, gridlines, title, etc.). The Issue shows up 15 times, each with the border of the graph. Every property is identical other than query and field names, but one works and one doesn't.

Any help understanding how to create a graph like this would be very appreciated.

Thanks!

Mike

 
You might want to take a look at the "Report with chart using 2 link fields" sample at Once you save the file to your local drive, you will need to view its properties and click the Unblock to allow you to extract and run the sample.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
dhookom - Thanks for your response. I took a look at your sample, but don't see anything different there than on mine... except mine don't work. Mine wants to put all 15 "categories" on the same X-value as one series. Or, the graphs show up with only the borders (the query returns correct data).

I'll keep at it, but if anyone has any suggestions I'd be most grateful.

Mike
 
It would help us to know/understand your Row Source and Link Master/Child properties.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top