Excel help - visualising schedule of talks

Soldato
Joined
27 Dec 2005
Posts
17,310
Location
Bristol
I've got a schedule of talks happening on a day - 251 talks, 83 unique, in 49 different places.

The columns in excel are talk name, start time, end time and room number.

What I want to is visualise this in a Gantt/calendar-style chart whereby the x-axis is time, the y-axis is room number, and then the talks span the period of time with the talk name as their label. There'll obviously be 49 rows, one for each room.

Solution may even not be in Excel but I've no idea how you would import that info into a calendar say.

Help!
 
Back
Top Bottom