Results 1 to 3 of 3

Thread: Autoscale Chart

  1. #1
    Join Date
    Sep 2004
    Posts
    4

    Exclamation Unanswered: Autoscale Chart

    Dear Excelist..

    How do I autoscale my chart everytime the X-axis value changes?
    I code my program using VB 6.0. Can anyone give me some pointers? Thanks a lot!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Quote Originally Posted by NicoleK
    Dear Excelist..

    How do I autoscale my chart everytime the X-axis value changes?
    I code my program using VB 6.0. Can anyone give me some pointers? Thanks a lot!
    Howdy,

    Right click on the axis, then choose Scale tab. Make sure that all the Auto options on the top portion are all checked.
    Last edited by shades; 09-15-04 at 12:51.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    abd remeber to record a macro at the same time that will give you the vba code which you can reference from vb as long as you set the reference to the excel com object library

Posting Permissions

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