Charting/Graph Question

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

Does anyone know if a chart will print multiple pages if
the data extends beyond the capacity of the Chart/Graph
control similar to a regular report printing multiple
pages if the data span calls for it. If it is possible to
have a chart/graph span multiple pages, can someone
explain the property setting that would allow that to
happen? If it's not possible, can you let me know that too?

Thanks,
 
Hello Cameo,
I am struggling to get charts working in reports - Access97.
I have checked out the Chart Wizard - that only allows six fields ?? I need
to chart about a dozen.
I have also tried to make some sense of the sample database - Northwind etc

Is there any online resource available to help get to grips with charts in
Access reports?

WSF
 
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
 
Back
Top