Contiguity / Barcode chart (use case)
You can build a Contiguity or Barcode chart with the help of the Gantt chart type.
Use case
You have a table with columns containing names of employees, the start and the end of working hours day by day.
You are going to build a chart with time ranges of daily working hours shown according to an employee's name.
Source table
Your source table looks like the table below.
Name | Start of the working day | End of the working day |
|---|---|---|
Brad Hayes | 2025-04-10 08:00 | 2025-04-10 20:00 |
Molly Gibney | 2025-04-10 08:00 | 2025-04-10 20:00 |
Peter Green | 2025-04-10 08:00 | 2025-04-10 20:00 |
Cathy Holmes | 2025-04-10 08:00 | 2025-04-10 20:00 |
Brad Hayes | 2025-04-11 08:00 | 2025-04-11 20:00 |
Molly Gibney | 2025-04-11 08:00 | 2025-04-11 16:00 |
Peter Green | 2025-04-11 08:00 | 2025-04-11 12:00 |
Cathy Holmes | 2025-04-11 08:00 | 2025-04-11 12:00 |
Brad Hayes | 2025-04-12 08:00 | 2025-04-12 20:00 |
Molly Gibney | 2025-04-12 08:00 | 2025-04-12 12:00 |
Peter Green | 2025-04-12 08:00 | 2025-04-12 18:00 |
Cathy Holmes | 2025-04-12 08:00 | 2025-04-12 18:00 |
Brad Hayes | 2025-04-13 14:00 | 2025-04-13 20:00 |
Molly Gibney | 2025-04-13 14:00 | 2025-04-13 20:00 |
Peter Green | 2025-04-13 08:00 | 2025-04-13 20:00 |
Cathy Holmes | 2025-04-13 08:00 | 2025-04-13 20:00 |
Brad Hayes | 2025-04-14 10:00 | 2025-04-14 20:00 |
Molly Gibney | 2025-04-14 10:00 | 2025-04-14 20:00 |
Peter Green | 2025-04-14 08:00 | 2025-04-14 16:00 |
Cathy Holmes | 2025-04-14 08:00 | 2025-04-14 16:00 |
Brad Hayes | 2025-04-15 08:00 | 2025-04-15 16:00 |
Molly Gibney | 2025-04-15 08:00 | 2025-04-15 12:00 |
Peter Green | 2025-04-15 08:00 | 2025-04-15 12:00 |
Cathy Holmes | 2025-04-15 08:00 | 2025-04-15 20:00 |
Solution
- Wrap the table with the Chart from Table macro.
- Choose the Gantt chart type.
- Set the required Labels and Values columns.
- Specify the correct Date format and other options if needed.
