+ Reply to Thread
Results 1 to 3 of 3

Evenly spaced X Axis not required

  1. #1
    Registered User
    Join Date
    10-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Evenly spaced X Axis not required

    Hi,
    My data is as follows: As the dates are unevenly spaced its hard to bring out the features with an evenly spaced x axis. How can I make the x axis show only the dates that I sampled?
    Thanks
    Apr-89 3.86
    Mar-90 1
    Jan-91 0.8
    Apr-92 0
    Apr-93 4.21
    Jun-95 0.29
    Dec-96 3.86
    May-98 1.57
    Mar-99 4.43
    Nov-00 2.89
    May-04 0
    Jan-06 4.39
    May-06 0
    Nov-06 2.59

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,651

    Re: Evenly spaced X Axis not required

    Not sure what you mean.
    But take a look at this.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: Evenly spaced X Axis not required

    Is the attached file what you are looking for?

    Hope this helps.

    Pete
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Format rows so they're evenly spaced
    By fb718 in forum Excel General
    Replies: 11
    Last Post: 06-22-2011, 06:03 PM
  2. How to get graph axis to have evenly spaced values.
    By JamesWMH in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-21-2010, 11:29 AM
  3. i have to add cells evenly spaced, eg a1 + a11+a21+...+a991
    By mcutlac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2006, 02:35 PM
  4. Can't get evenly spaced chart x-axis labels
    By tcarp in forum Excel General
    Replies: 3
    Last Post: 04-24-2006, 08:10 PM
  5. [SOLVED] Variable dates on X axis evenly spaced (should not be)
    By Leo Bueno in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-24-2005, 12:05 PM

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