Access 97 Graphs

[jon]

Hi
I have a query that returns data that needs to be graphed in excel as Access
97 graphs are not capable.

I would like to display the graph from access if possible?
Or will I have to open excel separately to see the graph?

What is the best way I can achieve this?
Advise please.

Thanks in advance
Jon

 

[Rick Brandt]

Hi
I have a query that returns data that needs to be graphed in excel as Access
97 graphs are not capable.

Why do you think Access cannot graph it? It is the same graph engine in all
Office Apps.

 

[jon]

Hi Rick
I have tried but access just will not display all the data properly.
We have an old spread sheet we are trying to replace that displays it
correctly.

I have managed to make a graph but it will not handle the amount of data
required.

I have also asked a friend who is more experienced with access and he has
tried and come to the same conclusion.

Thanks Jon

 

[Rick Brandt]

Hi Rick
I have tried but access just will not display all the data properly.
We have an old spread sheet we are trying to replace that displays it
correctly.

I have managed to make a graph but it will not handle the amount of data
required.

I have also asked a friend who is more experienced with access and he has
tried and come to the same conclusion.

Did you use the chart wizard? (waste of time).

I always make my charts in forms. They can be transferred to reports when
finished, but I never try to create them in reports. In a form you make the
chart Enabled = True and Locked = False. That allows you to bring up the chart
designer while in normal view of the form as opposed to design view. That
ensures that the chart in the designer will be using your data rather than
sample data.

One in the chart designer you should be able to do anything you can do in Excel.