Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Customising X axis (2003)

    I'm trying to plot a graph to show the profile of a hill. On the Y axis I have the altitude and on the X axis I have the distance covered.

    What I'm finding is that the gradients are some what distorted because the spacing between the X axis points are evenly spaced. (EG: I....I....I....I....I)
    Is there a way to show the values of the x axis as they appear in my data table rather than even spaces? (EG: I....I.......I..I..I..........I)

    I hope my question makes sense??

    Regards
    Hayden

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Customising X axis (2003)

    Change the chart into an XY Scatter chart. In an XY chart, both the X and Y axes are treated as numeric. In other chart types, the X axis is treated as categories.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Customising X axis (2003)

    Great Hans, thanks very much!

    I thought this was going to be a major job requiring complex coding etc., but it's turned out to be so simple.

    Thanks again, Hayden

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Customising X axis (2003)

    <hr>I thought this was going to be a major job requiring complex coding etc., but it's turned out to be so simple.<hr>
    We could still suggest a solution that does require rocket-science level VBA and formulas if you like <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Customising X axis (2003)

    Ok, go on then.. <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>

    You've got me intrigued now (not that I'm likely to understand or implement it <img src=/S/woops.gif border=0 alt=woops width=58 height=36>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Customising X axis (2003)

    I was really kidding this time. I would know no way to fool Excel into showing something else than categories on charts other than xy-scatter.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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