View original (French)

Date on the X-axis

Solved
Cabrina Posted messages 273 Status Member -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello,

I have a table with the dates of working days, then two columns with data that I enter based on my productions.
When I create my chart, the x-axis automatically includes all the dates (Saturday and Sunday included).
How can I ensure that only the dates from my table are displayed?

Thank you in advance

3 answers

  1. Anonymous user
     
    Hello,
    You could try this:
    https://www.cjoint.com/c/HHCkSlAhCFD
    done on an old Excel 2003. The formula converts "numeric" dates into "text".
    Best regards,
    Alain
    2
    1. Cabrina Posted messages 273 Status Member 8
       
      Thank you very much, that's exactly it!!!

      Have a nice day.
      0
    2. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
       
      Hello,
      With an old 2003 version, going through an intermediate "text" formula is not necessary.
      The Axes Options tab of the chart offers 3 possibilities: Automatic, Category, Chronological; you just need to choose Category.
      The same choice exists in newer versions but is presented differently. (The term chronological has disappeared)
      The default value is "Automatic" and as soon as Excel can interpret data as dates, it is the numerical value of the dates that takes precedence.
      0
  2. ccm81 Posted messages 11033 Status Member 2 434
     
    I suggested the scatter plot type to get a real scale on the horizontal axis.
    You can simplify Alain-92's formula, which I salute by the way, in D6
    =TEXT(B6;"dd/mm/yy")

    Best regards.
    1
  3. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    With the Scatter plot type
    https://www.cjoint.com/c/HHCjvgLuTlB

    Best regards
    0
    1. Cabrina Posted messages 273 Status Member 8
       
      Ccm81 thank you for your response.

      I must not have the same version of Excel as you because I cannot find "axis format - pattern."

      What I forgot to mention in my previous post is that my chart is a histogram.

      Best regards,
      0