How to Draw a Pie Chart in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Create a pie chart in Excel

How to Draw a Pie Chart in Excel

How to draw a pie chart in Excel will also be shared by Mytour in the following article to help you effectively use the Excel office application, support in work.

If you already know how to draw a column chart in Excel to illustrate the numbers on the worksheet more visually, then the following content, we will guide you on how to create or draw a pie chart in Excel

Create a pie chart in Excel

How to Draw a Pie Chart in Excel

In this article, Mytour will use Excel 2016 to demonstrate how to draw a pie chart in Excel.

Assume you have a data table like the one below that needs to insert a pie chart.

Step 1: You select the data to draw the pie chart.

Step 2: Then go to the Insert tab -> select the pie chart icon, you can choose the type of chart you want to draw, for example, you choose the 2 - D Pie pie chart.

Step 3: After you have made your selection -> the pie chart type will appear in the Excel worksheet.

If you want to change the data in the worksheet -> when the data changes, the chart will automatically update accordingly. For example, in January, if I enter an increase in data -> then you will see the pie chart also change accordingly.

So, with the 3 steps just guided above, you have successfully drawn a pie chart in Excel. After creating the chart, you can still edit the chart such as:

- Add other components to the chart:

You click on Chart Elements will see additional small features:

+ Chart Title: Add a title to the chart.

+ Data Labels: Add data labels to the chart.

+ Legend: Add a legend to the chart.

- Change colors and chart styles in Excel

To change the colors and appearance of the pie chart -> you click on the Chart Styles icon as shown in the image below you can choose the style and color of the chart to best fit.

- Use filtering or display data

For example, if you want to blur the data of 2 months, February and March, and want to clearly show the data of January, you click on Chart Filters -> select the data you want to display will succeed.

Here is a trick to help you know how to draw a pie chart in Excel version 2016. If you are using other versions of Excel such as Excel 2003, 2007, 2010, 2013, refer to how to create a pie chart in Excel here to know how to do it. You can also see more effective ways to draw shapes in Excel.

See more: How to draw shapes in Excel

Frequently Asked Questions

What are the steps to create a pie chart in Excel 2016?

To create a pie chart in Excel 2016, first select your data. Next, go to the Insert tab and choose the pie chart icon to select the chart type you prefer. Finally, your pie chart will appear in the worksheet, ready for further customization.

How can I update a pie chart automatically when data changes in Excel?

Yes, your pie chart will automatically update when you change the data in the worksheet. This feature allows for dynamic visual representation of your data without needing to redraw the chart each time you make an adjustment.

What options are available for customizing a pie chart in Excel?

You can customize a pie chart in Excel by adding chart elements like titles and data labels, changing colors and styles, and applying filters to display specific data segments. These options enhance the chart's clarity and visual appeal.

Is it possible to create a pie chart in versions of Excel prior to 2016?

Yes, pie charts can be created in earlier versions of Excel, including 2003, 2007, 2010, and 2013. The process may vary slightly, but the fundamental steps for inserting and customizing a pie chart remain similar.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]