View original (French)

Date axis chart type

Mych -  
Hello,

In the Excel 2016 version I am using, it seems that the option to choose between "text" or "date" axis types is not available.
Could you please tell me if this is normal? I would like Excel to recognize that these are dates so that I can set the unit to months or years.

3 answers

  1.  Raymond PENTIER Contributor
    Good evening.
    • In the data table, the dates must be in DATE format.
    • In Axis formatting, in the last section NUMBER, you need to select the category Date and check "Link to source".

    --
    It's nice, retirement! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. Mych
      Hello,
      Thank you for your response. I indeed proceeded like that.
      My problem is that despite this, in the right sidebar for formatting the horizontal axis, the dates are still being handled as numbers.

      However, if I want to display only the first of the month on the graph axis, this is difficult because I cannot input a monthly interval for example.

      Best regards,
      0
  2. Raymond PENTIER Contributor
    I had indeed tested it before replying to you, and I was getting the 1st of the month...
    All that's left for you to do is send your Excel file so we can try to spot the error. 
     1) Go to https://www.cjoint.com/ 
     2) Click on [Browse] to select your file (max 15 MB)
     3) Scroll down to click the blue button [Create Cjoint link] 
     4) After a few seconds, the second page will appear, with the link in bold; right-click on it and choose "Copy link"
     5) Go back to your discussion on CCM, and in your message, do "Paste".
    =>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers 
    There are also: 
     1) https://mon-partage.fr/ 
     2) https://www.transfernow.net/

    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0
    1. ccm81
      Hello to both of you

      You have a solution by adding a series of data
      https://mon-partage.fr/f/oqR2aCru/

      Best regards
      0