classroom shedule.xlsx

Hello,

My apologies if I am doing anything wrong on this post this is my first time on this forum!

I am trying to create a schedule to show what locations and classrooms will be in use at a given time.

In the main spreadsheet I will have the dates, location and specific classroom information number of people etc...

I want to create a calendar and have those points automatically plotted into the correct place in the calendar when I update the master sheet. Also I would like to figure out if on the graph it can specify the number of people who will be attending.

I attached what I have started with some sample data to avoid any confusion. I have used excel before but nothing this advanced.

Any help would be appreciated.

Thank You