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

Answer 1 / 3
Raymond PENTIER Posted messages 58205 Registration date   Status Contributor Last intervention   17 475
 
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
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
Answer 2 / 3
Raymond PENTIER Posted messages 58205 Registration date   Status Contributor Last intervention   17 475
 
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
Answer 3 / 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