Charts in Access Reports

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 Hookom
MS Access MVP
--

"Bill" wrote in message
k.net...
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

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


"Duane Hookom" wrote in message
...
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 Hookom
MS Access MVP
--

"Bill" wrote in message
k.net...
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

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 Hookom
MS Access MVP
--

"Bill" wrote in message
news
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


"Duane Hookom" wrote in message
...
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 Hookom
MS Access MVP
--

"Bill" wrote in message
k.net...
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

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


"Duane Hookom" wrote in message
...
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 Hookom
MS Access MVP
--

"Bill" wrote in message
news
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


"Duane Hookom" wrote in message
...
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 Hookom
MS Access MVP
--

"Bill" wrote in message
k.net...
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