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 for six weeks.

You are going to build a chart with time ranges of working hours shown according to an employee's name day by day.

Solution:

  1. Wrap the table with the Chart from Table macro.
  2. Choose the Gantt Chart type.
  3. Set needed Labels, Values column(s) in the chart controls.
  4. Specify the correct Date format and other options if needed.