Consulting

Results 1 to 3 of 3

Thread: Assign Minimum and maximum values for a MSChart

  1. #1

    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

  2. #2
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    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
    K :-)

  3. #3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •