View original (French)

Date axis chart type

Mych -  
ccm81 Posted messages 11033 Status Member -
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 Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    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 Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    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
  3. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello to both of you

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

    Best regards
    0