Subject: scale properties in diagram

[S. van Beek]

Dear reader,

A Microsoft Graph 2000 chart is as OLE class available in a form.

If the form opens a diagram will be produced.

Because of the variation in the figures for these diagrams the axis has to
be changed manually by double click the axis.

After the double click a form "Format Axis" pops up with a tab "Scale" in
which the values,

Minimum, Maximum, Major unit and Minor unit can be set.

The question is, is there a possibility to change the axis scales by setting
axis properties in the event

"On open" of the form.

Thanks for any help.

Kind regards,

Simon van Beek

[David Lloyd]

Simon:

You may find the following KB article a good reference.

http://support.microsoft.com/default...b;en-us;158938

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:42*********************@reader1.nntp.hccnet.n l...
Dear reader,

A Microsoft Graph 2000 chart is as OLE class available in a form.

If the form opens a diagram will be produced.

Because of the variation in the figures for these diagrams the axis has to
be changed manually by double click the axis.

After the double click a form "Format Axis" pops up with a tab "Scale" in
which the values,

Minimum, Maximum, Major unit and Minor unit can be set.

The question is, is there a possibility to change the axis scales by setting
axis properties in the event

"On open" of the form.

Thanks for any help.

Kind regards,

Simon van Beek