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

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

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

This embedded resource is unavailable in the restored edition.

Here is the sample file:

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

Steve=True

Reader discussion

Comments preserved from the original page. New comments are closed.

December 19, 2018 At 2:43 pm

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?

December 20, 2018 At 1:59 pm

Thanks Manon, did you try and upload it already? I ask because it may work for conditional one but not for the chart one.

Reader discussion