Charts in Access Reports

B

Bill

I have been trying to more-or-less duplicate a
chart in Access 2000 from what I typically do
in Excel 2000. All I want is to plot a line graph
of values over time. Access doesn't seem to do
anything other than offer various summaries of
data. Am I missing something?

Bill
 
D

Duane Hookom

You can use the wizard to create the chart. Once it has finished, you can
edit the Row Source property to plot the data values you desire. Sometimes
the wizard is too helpful.
 
B

Bill

Duane,
The Row Source was, of course, easily enough to change.
However, the chart datasheet still summarizes about 158
data points into 4 quarters and creates 3 line graphs of
East, West and North.

If there's a property that controls how the Row Source is
to be graphed, I haven't been able to find it.

I tried to import my "Excel Version" of essentially the same
graph, but the properties for the Excel version must be
very different than what Access used, as the chart is at
best very distorted.

Bill
 
D

Duane Hookom

Do you see North, etc when you view the chart (not in design view)?

To see your actual data in design view, open the datasheet view of the chart
control and copy all the records to the clipboard. Then go to the chart
design view and view its datasheet. Delete the existing records and paste
from your row source datasheet.
 
B

Bill

Duane,
I got a major interruption going here, but will return
to this problem in a day or so.
Bill
 
Top