Access 97 Graphs

  • Thread starter Thread starter jon
  • Start date Start date
J

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
 
jon said:
Hi
I have a query that returns data that needs to be graphed in excel as Access
97 graphs are not capable.
Click to expand...

Why do you think Access cannot graph it? It is the same graph engine in all
Office Apps.
 
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
 
jon said:
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.
Click to expand...

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