PDA

View Full Version : Assign Minimum and maximum values for a MSChart



abiram01
03-15-2006, 11:19 PM
Hi all,

I want to assign values for minimum and maximum for all MScharts. For that am using the followind code in a loop.

oGraph.Axes(xlValue).MinimumScale = 5000
oGraph.Axes(xlValue).MaximumScale = 15000

Here what is the problem is the values are assiged while execution the above instructions and again reassinged the old values for maximum and minimum.

Please let me know this is happening?


Regards,
Abhiram

Killian
03-16-2006, 02:05 AM
Is there something happening after this in the code that might affect this?
Using MinimumScale/MaximumScale sets MinimumScaleIsAuto/MaximumScaleIsAuto to False so it should be OK

abiram01
03-16-2006, 02:57 AM
Is there something happening after this in the code that might affect this?
Using MinimumScale/MaximumScale sets MinimumScaleIsAuto/MaximumScaleIsAuto to False so it should be OK

There's no code after this. This in with in a loop. So the loop will set the maximum and minimum values for all the charts.

Thanks killian.