导出excel 带图表_带有图表的Excel座位计划

导出excel 带图表

If you're planning a wedding, or another type of event, you might need a seating plan. Get this free Excel seating plan with charts, and modify it to show your guest names and table arrangement.  See how to use the sample file, and how to add more guests and tables.

如果您打算举行婚礼或其他类型的活动，则可能需要座位表。 获取带有图表的免费Excel座位计划，并对其进行修改以显示您的客人姓名和餐桌布置。 了解如何使用示例文件，以及如何添加更多的来宾和表。

旧Excel座位计划 (Old Excel Seating Plan)

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.

这个带有图表的座位计划是我很久以前(2006年)发布的一个新版本，并且新版本更易于使用。

You can read details about the old version, including how it was set up. That version used drop down lists, based on a formula that hid the guest names after they were assigned to a table.

您可以阅读有关旧版本的详细信息 ，包括如何设置。 该版本使用下拉列表，基于一个将访客名称分配给表后将其隐藏的公式 。

The tables and chairs were circle shapes, and each chair was linked to a cell. 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.

桌子和椅子是圆形的，每把椅子都链接到一个牢房。 如果您没有太多的客人，那很好，但是为一个大型聚会添加更多桌子和座位的过程很漫长。

带有图表的Excel座位计划 (Excel Seating Plan with Charts)

I just created a new version, which is easier to use. Instead of circle shapes, this plan uses doughnut charts - thanks to Oz du Soleil for that idea.

我刚刚创建了一个新版本，它更易于使用。 该计划使用圆环图代替圆形，这要感谢Oz du Soleil的想法 。

The main sheet in the workbook is named TablePlan. On that sheet, you assign guests to seats at the different tables.

工作簿中的主要工作表名为TablePlan。 在该工作表上，您将客人分配给不同桌子上的座位。

For each table, the guest names and table number cells are the source data for one of the doughnut charts. The chart for Table 1 is shown below, with its source data highlighted.

对于每个表，来宾名称和表号单元格是其中一个甜甜圈图的源数据。 表1的图表如下所示，其源数据突出显示。

带有图表的Excel座位计划 (Excel Seating Plan with Charts)

Here's what I'll cover in this blog post:

我将在这篇博客文章中介绍以下内容：

• First, I'll show you how to use the sample file, with the fake guest list.
  首先，我将向您展示如何使用示例文件以及伪造的来宾列表。
• Later, you'll see how to add more guests or tables to the Excel seating plan with charts, or change the number of seats per table.
  稍后，您将看到如何向带有图表的Excel座位计划中添加更多客人或桌子，或如何更改每个桌子的座位数。
• After that, if you're interested in the setup details, I'll explain the formulas and other features in the sample file.
  之后，如果您对设置详细信息感兴趣，我将在示例文件中解释公式和其他功能。
• Finally, there is a link where you can