+ Reply to Thread
Results 1 to 11 of 11

Excel 2013 Date axis problem

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Excel 2013 Date axis problem

    Hi i'm having trouble getting the dates i want on the horizontal axis on a chart in Excel 2013. I want 12 dates along the axis starting at 01/01/2013 then each month until 1/12/13 however as you can see the dates are 01/01/1900. Ive googled this problem but dont understand how to fix it. Any help is appreciated.

    Thanks

    Matt
    Attached Images Attached Images

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Excel 2013 Date axis problem

    If you right click the dates and select "Format Axis" which option it selected under "Axis Type"?

  3. #3
    Registered User
    Join Date
    04-12-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Excel 2013 Date axis problem

    Date axis is selected

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Excel 2013 Date axis problem

    I just created something similar with the "Automatically select based on data" option selected and it worked fine.

    May be something to do with the way your data it stored (i.e. not true date format) but without seeing some sample data it's difficult to diagnose the true problem.

  5. #5
    Registered User
    Join Date
    04-12-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Excel 2013 Date axis problem

    What is the correct way to sort the data?

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Excel 2013 Date axis problem

    Not sure what you mean?

    I said "store" not "sort".

    If your dates are stored as text for example, this could cause issues with the axis display.

    Post some same data with the graph not working and it will make it much easier to see what's wrong and to provide a solution.

  7. #7
    Registered User
    Join Date
    04-12-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Excel 2013 Date axis problem

    Heres the data im usingdata.xlsx

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Excel 2013 Date axis problem

    Is there a specific reason you only have the 1st of each month in column A?

  9. #9
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Excel 2013 Date axis problem

    Have a look at the three sheets on the attached.
    I've included brief notes in each to explain.
    Is this of any help to you?

  10. #10
    Registered User
    Join Date
    04-12-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Excel 2013 Date axis problem

    Yes thats great thanks second sheet is fine.

  11. #11
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Excel 2013 Date axis problem

    Happy to help.

    Don't forget to mark your thread as SOLVED if you're happy you have a working solution.

    BSB.

+ 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. [SOLVED] Problem with IsNumeric in Excel 2013 VBA
    By gurs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-04-2014, 06:00 PM
  2. [SOLVED] Date autofilter problem - Excel 2013 version
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2014, 12:10 AM
  3. Secondary non-proportional x-axis on chart (Excel 2013)
    By mayache in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-24-2013, 07:16 AM
  4. Simple formula to display a date (10/19/2013) as text (October 2013)
    By benyben123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2013, 03:47 AM
  5. Excel 2013 date updating problem
    By samson jerry in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2013, 02:30 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