Forum Discussion

Virtual123's avatar
Virtual123
Copper Contributor
Nov 20, 2023

Employee planned hours gant calendar

Hello, We currently have a calendar list view that shows each consultant planned hours/day, there are 3 types of hours, ''free'' ''internal'' & ''work''. A day can consist of all 3 types of hours or ...
Charting
excel
Formulas and Functions
Virtual123's avatar
Virtual123
Copper Contributor
Nov 22, 2023
Looks very good! Thank you for the help, is it possible to transpose the hours into 3 rows instead of columns? That way more dates can fit the page
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 22, 2023

Virtual123 

 is it possible to transpose the hours into 3 rows instead of columns? That way more dates can fit the page?

 

Not sure I understand... that would give you what you already have:

  • Virtual123's avatar
    Virtual123
    Copper Contributor
    Nov 22, 2023

    Ah yeah youre right. my bad. What i meant is something like this with a gantt chart combined with what you made Lorenzo 

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Nov 22, 2023

      Ah ah Virtual123  I virtually know (from forums) who created what you shared and better understand what you actually expect *


      I'm not at all specialized in charts and haven't played with VBA for years. I can help with Power Query and Power Pivot (to a certain extent) to shape the data but that's about it I'm afraid. Sorry but I don't how I can help you further with this matter... (IMHO what I shared earlier does it)

       

      * A Gantt chart represents activities (Categories in your case) row by row and not stacked horizontally on a timeline

Resources