• 欢迎访问速搜资源吧，如果在网站上找不到你需要的资源，可以在留言板上留言，管理员会尽量满足你！

# 【速搜问答】Excel中如何做饼形图

9个月前 (03-13) 155次浏览

Chinese-English Translation:

Pie chart is a chart based on numerical data, which can show the percentage of the size. After inputting certain data in Excel, you can select the data and create a pie chart. You can try to use the pie chart of Microsoft Excel to enhance the visual effect of data in demonstration or business project.

input data

1、打开 Microsoft Excel 电子表格软件。输入要创建为饼形图的数据。

1. Open Microsoft Excel spreadsheet software. Enter the data you want to create as a pie chart.

2、创建简单数据系列。饼形图只用于一个系列的数据。

2. Create a simple data series. The pie chart is only used for a series of data.

For example, pie chart can be used to show the time proportion of daily activities. For your simple data series, you need to list a list of activity names and minutes or hours used. You can use it in Business Computing to calculate the various components of team sales, or the proportion of website traffic from each major data source.

3、继续下一步前把数据保存好。

3. Save the data before continuing.

Select data

1、选中要画在饼形图的数据。鼠标拖动覆盖所有行、列，确保不要拖到别的系列的数据上。

1. Select the data to be drawn on the pie chart. Drag the mouse to cover all rows and columns, and make sure not to drag them onto other series of data.

Write the class alias in the selected data. For example, write “salesperson” at the top of one column and “sales quantity” in the other column. You can select these information so that excel can display the data classification correctly.

2、点击上方工具栏里的“插入”-“图表”，选择图表。

2. Click “insert” – “chart” in the toolbar above to select the chart.

3、选一种饼形图。你可以选普通饼形图、3D 饼形图，或分裂饼图、子母饼图、复合条饼图，每个选项都有其细节描述。

3. Choose a pie chart. You can choose ordinary pie chart, 3D pie chart, split pie chart, sub parent pie chart, composite bar pie chart. Each option has its own detailed description.

Click on the “hold down view examples” button to see what each image looks like.

4、选择好后点下一步，然后打开图表向导来修改。

4. After selecting, click next, and then open the Chart Wizard to modify.

Chart Wizard

1、在图表源数据画面查看图表预览。检查表格范围是否有错，确认数据系列是以行的形式还是以列的形式输入的，如果是一列，则选择“列”。

1. View the chart preview in the chart source data screen. Check whether there is an error in the table range, and confirm whether the data series are entered in the form of row or column. If it is a column, select column.

2、点击下一步，到“图表选项”。

2. Click next to go to chart options.

Select title to add a chart title.

Select data tab to display various data. For example, select “classification” and “percentage” to make a standard pie chart.

3、点击完成。然后就看到 Excel 表格中出现饼形图了。

3. Click finish. Then you can see the pie chart in the excel table.

4、点击编辑-复制，来复制整个图表。可以复制到报告、Word 文档或幻灯片中来作为数据的辅助。

4. Click Edit copy to copy the whole chart. You can copy to a report, word document, or slide to assist with the data.

Tip: return to the Chart Wizard to select the appropriate type of pie chart. Composite bar pie chart and sub parent pie chart can let you explain the data of a certain part in detail. Use a series of these icons to enhance the visual effect of your presentation.

[361009623@qq.com]

• 版权声明

本站的文章和资源来自互联网或者站长
的原创，按照 CC BY -NC -SA 3.0 CN
协议发布和共享，转载或引用本站文章
应遵循相同协议。如果有侵犯版权的资
源请尽快联系站长，我们会在24h内删
除有争议的资源。
• 网站驱动

• 友情链接

• 支持主题