+ Reply to Thread
Results 1 to 2 of 2

Trouble changing the format of dates in a chart

  1. #1
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Trouble changing the format of dates in a chart

    Hi,

    I've gone to Format Axis > Number > Date and changed the date format to what I want but it doesn't effect the change I want. Can anyone take a look and advise. Details in example:


    change date in chart example.xlsx

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

    Re: Trouble changing the format of dates in a chart

    If you right click the Row Labels field you will see, or more accurately you will not see, the Number Format button is missing.
    This is due to the Blank data.
    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