Hi Syd,
When I started doing charts, I was using Access 2000, so I don't know if
there were changes to the charting function from Access 97 to Access 2000.
I actually bumbled into figuring out how to chart, so I don't have any
resources other than the trial and errors in my brain
Lastly, when I chart, I use the chart's ROW SOURCE to build the chart query
rather than VBA (b/c I don't know how).
The output of the Source Code below is the "Umpire Ratings - All Seasons ~
Baseline ~" chart on page 1 in the following report. (The entire report is
built in Access).
http://www.bostonwestcoedsoftball.com/bwcs_ump_ratings/r-UmpireRatings.pdf
SELECT Sum([UMPRatingsCount_Crosstab].[0]) AS name,
Sum([UMPRatingsCount_Crosstab].[1]) AS Poor,
Sum([UMPRatingsCount_Crosstab].[2]) AS [Below Avg],
Sum([UMPRatingsCount_Crosstab].[3]) AS Average,
Sum([UMPRatingsCount_Crosstab].[4]) AS Good,
Sum([UMPRatingsCount_Crosstab].[5]) AS Excellent FROM
UMPRatingsCount_Crosstab;
To create graphs, I have found that you usually need to have a CROSSTAB
query, either as a Reference (above is a a Select query referencing a
crosstab query) source or as the Direct (the crosstab query is used
directly) source ...not sure if I'm using the right lingo, but hopefully,
you get what I mean.
The one thing you need to know is that you should NOT rely on the visual
depiction of the graph in DESIGN view, as it is NOT always representative of
your Source code. You actually need to PREVIEW the report to see if the
chart is correct. In fact, I rarely look at the visually depiction anymore,
other than to size the chart within the image boundaries and to make sure
it's the correct chart type (pie rather than column, etc.).
I hope this helps. Email the group if you have more questions. And if I can
help, I will.
Cameo
