Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    London, Ontario
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    X-axis labels (2003)

    This is going to sound really stupid, but here goes:

    I am creating a line graph using three sets of numbers.
    8.8 171.3 230.3 470.7 578.5 704.7
    7 140 298 494 1159 1513
    7 112 227 448 1091 1215
    I want to use the first set for the X axis and the other two for the two data series (i.e. the lines on the graph).

    When I create the graph, the Y axis has ticks, and values from 0, 200, 400, etc. It does this automatically. Fine.
    However, the X axis shows the actual values, 8.8, 171.3, etc. I want it to show 0, 100, 200, etc. and place the actual values at the appropriate places along X. This is not rocket science. But can I get it to do this? No, I cannot. there seems to be nowhere where I can set the tick values for the X axis.

    Roger Shuttleworth
    London, Canada

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: X-axis labels (2003)

    Don't use a line chart. The Line chart X-axis is "categories"

    Use an XY scatter, which uses values for the X-axis.

    Steve

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    London, Ontario
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: X-axis labels (2003)

    Thanks, Steve. So simple...
    I guess "scatter" wasn't intuitive enough for me.

    Roger

Posting Permissions

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