![]() ![]() The chart for Table 1 is shown below, with its source data highlighted. On that sheet, you assign guests to seats at the different tables.įor each table, the guest names and table number cells are the source data for one of the doughnut charts. ![]() The main sheet in the workbook is named TablePlan. Instead of circle shapes, this plan uses doughnut charts – thanks to Oz du Soleil for that idea. I just created a new version, which is easier to use. ![]() That worked well, if you didn’t have too many guests, but was a lengthy process to add more tables and seats for a large party. The tables and chairs were circle shapes, and each chair was linked to a cell. That version used drop down lists, based on a formula that hid the guest names after they were assigned to a table. You can read details about the old version, including how it was set up. This seating plan with charts is a new version of one that I posted long ago (2006), and the new version is easier to use. See how to use the sample file, and how to add more guests and tables. Get this free Excel seating plan with charts, and modify it to show your guest names and table arrangement. If you’re planning a wedding, or another type of event, you might need a seating plan.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |