Assign Minimum and maximum values for a MSChart

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

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

Quote:

---

Originally Posted by Killian

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.