Forum Discussion

esteban_ab's avatar
esteban_ab
Occasional Reader
Oct 03, 2025

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)

No RepliesBe the first to reply

Resources