charts

[dave_b]

I have been trying to find out how to insert a decent chart into an Access
report for three weeks. The chart supplied is a piece of crap; I have yet
to get it to produce accurate results. I have tried to insert the Active X
control chart - but it will not recognize version 2007. I'm pretty fed up,
and I'm about to start looking for a different program that can present data
graphically in a better way.

I thought I'd try one more time here. I have a lot of data from a local
multiple listing service. I'm trying to create summary reports for
individual developments in a single report - so I want a graph in the
development section of the report, for that development. What's happening
is that it shows the first development, and never changes. I have also tried
using a subreport. I have the main/child fields properly defined. This
should not be so hard!!~!@ I've been using Access since version 1, and to
my thinking, graphs has always been a short-fall of the program.

I must have graph ability at this time. Any help is appreciated - because
if I can't get it to work, I'll just have to press delete on Acccess.

 

[Bob Barnes]

Within Access, run automation to Excel charts.

Once the data is transferred to Excel, you can open
the Excel file w/ FollowHyperlink.

HTH - Bob

 

[Bob Barnes]

Let me know if you want an example of automation code.

I probably won't be back online until early next week,
but will check this thread then.

HTH - Bob