Forum Discussion
Group Timeline chart by unique values
I have a table in an excel spreadsheet in which we plan the team's vacation days (fig.1)
Note: in Brazil we can take up to 3 periods in a year - totalling 30 days - and 10 of those can be sold: you receive extra money and only take 20 days off
on column B the worker puts his name, column C-D the worker inputs start and end day of each vacation period
the other columns serve no purpose for the graph my question is about
Then, I select A2:J13 range and create a pivot table/chart with the following fields (fig.2)
My question is if there's a way to overlap the periods for a same worker (Samwise for example)
Each worker should have only one line and all vacation periods be on it (because 3 years from now there would be so many lines that the graph wouldn't be nice to see the time periods each one is on vacation)