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)
1 Reply
How about using Bar Chart with Overlapping Bars:
- Prepare your data:
- Keep each vacation period as a separate row.
- Ensure each row has the worker's name, start date, and duration.
- Create a stacked bar chart:
- Use the worker's name as the category axis.
- Use the start date as the base (invisible series).
- Use the duration as the visible bar.
- Format the chart:
- Set the base series to "No Fill" so only the duration shows.
- This will make multiple vacation periods appear on the same line for each worker.
- Prepare your data:
