Forum Discussion
Employee planned hours gant calendar
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:
- Virtual123Nov 22, 2023Copper Contributor
Ah yeah youre right. my bad. What i meant is something like this with a gantt chart combined with what you made Lorenzo
- peiyezhuNov 23, 2023Bronze Contributor
- LorenzoNov 22, 2023Silver Contributor
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