虽然为您提供了许多在Excel中创建图表的选项，但每个图表都有不同的范围和不同的用途。饼图通常是二维图表，用于比较两列之间的值。如果您想在Excel^(Excel)中创建饼图，请通读这篇文章。

如何在 Excel 中制作饼图

在本文中，我们将分层旭日^{(Hierarchical Sunburst)}图视为一种饼图，尽管添加它的过程略有不同。为仅分布在 2 列中的数据创建饼图的过程很简单。

选择有问题的 2 列中的数据。

• 单击Insert > Pie Chart。
• 然后选择二维^{( 2-D)}饼图。

二维饼图的大图如下：

• 如果您在使用二维饼图时选择超过 2 列的数据，图表将忽略前 2 列之外的条目。
• 分层旭日图^{(hierarchical sunburst chart)}的情况类似。
• 选择有问题的 2 列中的数据。
• 单击Insert > Other Charts > Hierarchical > Sunburst。

分层旭日图^{(hierarchical sunburst chart )}的大图如下：

该图表看起来类似于Excel工作表的饼图，但饼图中可能会提到这些值。

在Excel^(Excel)中制作跨多列数据分布的图表

理想情况下，饼图不是处理多列的最佳选择。这样做会进一步将每个饼图划分为跨列的条目。您应该尝试使用柱形图。但是，创建多列数据饼图的过程如下：

选择所有多列中的完整数据。

单击Insert > Pie Chart。

现在选择任何一个甜甜圈^(Doughnut)或3 维图表^{(3-dimensional charts)}。

应该注意的是，除了2-D^(2-D)图表之外的饼图选项即使您仅将它们用于 2 列，它们的工作方式也是一样的。

这里讨论的饼图本质上是静态的，这意味着即使您更改数据列表中的值，图表中的值也将保持不变。

如果您需要在数据列表更改时更改饼图中的值，请尝试在 Excel 中创建动态图表。^{(creating a dynamic chart )}

希望能帮助到你！

How to make a Pie Chart in Excel

While you are provided with a lot of options for creating charts in Excel, evеry chart has a different scope and different uѕe. A pie сhart is a usually 2-dimеnsional chart used for comparing valuеѕ between 2 columns. If you wish to create a pie chart in Excel, please read through this article.

How to make a Pie Chart in Excel

In this article, we would consider the Hierarchical Sunburst chart as a type of pie chart, though the procedure for adding it is a little different. The procedure to create a pie chart for data spread across 2 columns only is simple.

Select the data across the 2 columns in question.

• Click on Insert > Pie Chart.
• Then select the 2-D pie chart.

A larger view of the 2-D pie chart is as follows:

• In case you select data across more than 2 columns while using the 2-D pie chart, the chart will ignore entries beyond the first 2 columns.
• Similar is the case for a hierarchical sunburst chart.
• Select the data across the 2 columns in question.
• Click on Insert > Other Charts > Hierarchical > Sunburst.

A larger view of the hierarchical sunburst chart is as follows:

The chart will appear similar to the pie chart of your Excel sheet, but the values would probably be mentioned inside the pies.

Make a chart with data spread across multiple columns in Excel

Ideally, a pie chart isn’t the best option for those dealing with multiple columns. Doing so would further divide each pie into the entries across the columns. You should rather try a column chart. However, the procedure for creating a multiple column data pie chart is as follows:

Select the complete data across all multiple columns.

Click on Insert > Pie Chart.

Now select any of the Doughnut or 3-dimensional charts.

It should be noted that the pie chart options other than the 2-D chart would work the same even when you use them for just 2 columns.

The pie charts discussed here are static in nature, which means that the values in the chart will remain constant even when you change the values in the data list.

If you need the values to change in the values in the pie chart upon changes in the data list, try creating a dynamic chart in Excel.

Hope it helps!

Related posts

• 如何在 Excel 中制作饼图

• 如何在Windows 11/10中创建Radar Chart

• 如何在Excel spreadsheet中插入Dynamic Chart

• 如何在Excel中创建Organization Chart

• 如何在Excel中创建Bar Graph or Column Chart

• 如何在Excel中创建Pivot Table and Pivot Chart

• 如何在Excel中使用Rept Function

• 如何在Excel中使用CHOOSE function

• 如何计算Excel中的百分比increase or decrease？

• Microsoft Excel正试图恢复您的信息

• 如何在Windows 11/10中创建Tournament Bracket

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel spreadsheet锁定Chart position

• 如何Merge and Unmerge cells在Excel

• 如何在Excel中使用DGET function

• 如何在Excel中停止或关闭Workbook Sharing

• 如何在Excel中创建Combination Chart

• 如何在Excel使用EDATE and EOMONTH Functions

• 如何在Excel中使用Find and FindB functions