Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XY chart: Dynamic minimum x-axis w/o VBA (97 SR-2)

    Is there a trick WITHOUT using VBA to persuade Excel 97 SR-2 to dynamically set the _minimum_ value of the x-axis of a XY chart to start at/"just before" the minimum value of the x values ? Background: The minimum value depends on the calculated values / used units and I hate having to finetune it manually everytime I change the input. Everything else is linked (titles, axis titles, series textboxes, etc.).

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: XY chart: Dynamic minimum x-axis w/o VBA (97 SR-2)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> cri

    I don't think you can link the minimum value of the axis because it is based on the data itself. But maybe you can have a cell that does not get charted that has a value that the chart can be fooled into using.

    Maybe someone has a better solution.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XY chart: Dynamic minimum x-axis w/o VBA (97 SR-2)

    Wassim, thanks for tackling this one. A separate cell does not help, actually it was what I tried as I want to start before the minimum value as I need some space for the descriptors ( I hate series legend tables)

Posting Permissions

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