+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : HELP: How to change range of values for x and y axis

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    oregon
    MS-Off Ver
    Excel 2003
    Posts
    1

    HELP: How to change range of values for x and y axis

    Hello,

    I am trying to set the range of values for my x and y axes as such:

    0
    30
    60
    90
    60
    30
    0

    (no negatives)
    Like the numbering system on a quadrant compass. I would be appreciative if anyone knows how to do this!

    Thank you.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: HELP: How to change range of values for x and y axis

    You will need to fake the axes and build your own. You will also need to manipulate the data used in the chart.

    If you need more help you will need to explain your data and how you can tell whether a data point of (30,20) should appear against the first 30 or second 30 on the scale.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1