Syntax for changing chart in report

[Guest]

Hi,

I really hope some can help me b/c I'm losing my mind. I have a report that
has charts in it. I have been scouring the web trying to find the proper
code to reference a chart during the "Format" action of the report so that I
can properly adjust the Y-axis scale so that the min/max are not so far off
from the data series.

If the chart is named "absIndex", I can't find what the proper syntax is to
get into the chart and adjust the scaling.

From the sample code I've seen, several references refer to ChartSpace but
even after adding the OWC10.dll, I keep getting the error msg "Method or data
member not found".

Please, can anyone out there help me??

 

[Guest]

I finally came across something that works.

me![chartrname].object.application.chart.axes(2).minimumscale=

if anyone know of a better way, let me know.

Thank you.