VB/VBA Code to update a MSGraph Value

[VickyLeigh]

Can anyone tell me the VB Code to update the Maximum and Minimum values for the Y Axis Scale in a graph on a form - I need to be able attach this to the OnChange property of a button on a form if possible.
For the sake of argument I have a form called forma and a graph object on this graph called graph1

Thanks for any help [sig][/sig]

 

[DanAuber]

Vicky,

I'm afraid I can't help you here - but I'd like to know the answer too..... [sig]<p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br> [/sig]

 

[kaspi]

Hi
You could try this.

dim appGraph as graph.application

set appGraph = new graph.application

appGraph.Chart.Axes(xlValue).MinimumScale = 10
appGraph.Chart.Axes(xlValue).MaximumScale = 100

Kaspi

 

[Countermeasure]

Can anyone point me to any documentation, help files, books that feature VBA with MSGraph.

I'm using Access 97 and can't see anything about Graph in the Object Browser. Is my installation faulty?