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 ...
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.