MS Graph on Reports

[Bob Barnes]

Ben - Thank you.

I saw your question above, & I don't know for sure, but I
think you CANNOT statically set the x-axis values.

I have tried to "dynamically" use MS Graph & have been
unable to do so. Am seriously looking into running DBF
files / Queries to dynamically set appropriate values using
Excel Charts.

Will monitor what else might be said by others.

Bob

 

[Guest]

Bob,

There *are* a couple of "quirks" with Ms Graph on Reports, has to do with
Access and Graph passing data to eachother as well as allowing for
Master/Child filtering of data on the fly. We also don't have the macro
recorder but the code generated by the Excel macro recorder can be quickly
converted for use by Ms Graph in Access.

Ben posted my notes which recommend designing a graph on a form then copying
the object to your Report.

Steve