1 2 Previous Next 16 Replies Latest reply on Jul 10, 2017 9:59 AM by kettan

    How to display a daily number of guests based on the start and end dates of their stays at my hotel ?

    Romain Doutrepont

      Hi !

       

      From my hotel reservation list, I have the following three columns:

      - guest name

      - arrival date

      - departure date

       

      I want to display on a vertical bar chart, where every bar would represent a day, the number of guests that have stayed at my hotel.

      If I use the "arrival date" or the "departure date" in the Column field, all I can have is the number of guests sorted by arrival or departure date. I want to know the same of guests staying in every night.

       

       

      How can I do that? See the workbook attached.

       

      Thanks in advance for your help!

        1 2 Previous Next