View original (French)

[Excel] Chart - don’t show weekends

Solved
identifiant-comment Posted messages 351 Status Member -  
identifiant-comment Posted messages 351 Status Member -
Hello,

I made an Excel chart to track information progression over time.
In my spreadsheet, the dates are in a row. They appear on the vertical axis of my chart.
My problem is as follows: I did not intentionally include weekends in my spreadsheet, yet they appear in my chart :S
I have already done the following checks:
- in the selected data, the dates I used are displayed and the weekends are not
- in the axis formatting options, the dates are recognized and the main unit and the secondary unit are set to 1.
Does anyone have an idea that could help?

Thanks in advance for your help!

1 answer

  1.
    redaiwa Posted messages 370 Status Member 119
     
    Salam. :)

    Try putting your dates in text format in your table: the chart no longer shows weekends.

    Does that work for you as a solution?
    --
    "Repel evil with good; and behold, the one with whom you had animosity becomes a warm friend" (Quran)
    "The one who does not know how to share is impaired in his emotions" (Marc Levy)
    4
    1. identifiant-comment Posted messages 351 Status Member 54
       
      Great, it works.
      Solved on the first try, thanks!
      0