Using VBA to Dynamically Format a MS Graph in a Report

[jaaret]

Can VBA be used with OpenReport to format MS Graph elements, for instance changing the line color or the marker style of a data series?

Jaaret

 

[dhookom]

I would try set some code in the On Format event of the report section containing the graph control. To get the proper syntax, I usually create a similar graph in Excel. I turn on the macro recorder and perform the property updates. Then turn off the recorder and view the code that is created. You can then copy and paste the code into your Access report and make some minor modifications.

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[SkipVought]

Hi,

Yes. Check out the SeriesCollestion Collection and the Points collection.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}