How to draw a pie chart in Excel will also be shared by Taimienphi.vn in the article below to help you use Excel office application effectively, supporting in work.
If you already know how
Create a cycle chart in Excel
How to draw a pie chart in Excel
In this article, Software will use
Supposing you have a data table as below screenshot shown, need to insert a pie chart.
Step 1: You black out the data that needs to be drawn in a pie chart.
Step 2: Then go to the Insert tab -> select the icon of the pie chart, you can select the chart style to draw, for example, you select pie chart 2 – D Pie.
Step 3: After you have selected ->, the pie chart style will appear in the Excel spreadsheet.
If you want to change the data in the spreadsheet -> when the data changes, the chart will automatically update with that change. For example, in January 1, I enter data that increases -> then you see that the pie chart also changes.
So with the 3 steps just above, you can successfully draw a pie chart in Excel. When you finish creating the chart, you can also edit the chart such as:
– Add other elements to the chart:
You click on Chart Elements and you will see that there are additional small features:
+ Chart Title: Add a title for the chart.
+ Data Labels: Add data labels for charts.
+ Legend: Add notes to the chart.
– Change chart colors and styles on Excel
To change the color as well as the shape of the pie chart -> click on the Chart Styles icon as shown below, you can choose the chart style and color to best suit.
– Use filtering or display data
For example, if you want to blur the data of 2 months, February and 3 months, and want to clearly show the data of 1 month, click on Chart Filters -> select the part of data that you want to display will be successful.
Above is a trick to help you know how to draw a pie chart in Excel 2016 version. If you use other versions of Excel such as Excel 2003, 2007, 2010, 2013, refer to how to