Create a Excel Gantt Chart to Display a Music Festival Band Schedule

Here is Pete’s answer to the recent Music Festival Schedule Challenge.

Music Festival Stacked Bar Chart Gantt Chart 2

In this video, see how he used Index/Match functions as well as a helper row to create an easily expandable chart data set.

Music Festival Stacked Bar Chart Gantt Chart helper row

Here is the sample file:

Petes-Answer-to-Create-a-Chart-to-Display-a-Music-Festival-Schedule.xlsm

 

Thanks Pete!   Great and easy solution.  I way over complicated it.

Steve=True