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

GGUK_Sat_PU

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







2 COMMENTS

  1. Hello,

    this tutorial is absolutely amazing… until you realise that you’re using google excel and therefore can’t use your template.

    Any chance you could offer such tuto on google drive’s excel?

LEAVE A REPLY

Please enter your comment!
Please enter your name here