Charts in Access Reports

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
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.
 
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
 
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.
 
Duane,
I got a major interruption going here, but will return
to this problem in a day or so.
Bill
 
Back
Top