How to draw a pie chart in Excel 2016
If you already know how to draw a column chart in Excel that makes illustrating the data on the spreadsheet more intuitive, the following content, we will show you how to create or draw a pie chart in Excel.
How to draw pie charts in Excel
In this article, TipsMake will use Excel 2016 to demonstrate how to draw pie chart in Excel.
Suppose you have a data table as shown below, need to insert pie chart.
How to draw a pie chart in Excel 2016 Picture 1
Step 1: You perform the highlighting of the data you need to draw a pie chart.
How to draw a pie chart in Excel 2016 Picture 2
Step 2: Then go to the Insert tab-> select the icon of the pie chart, you can choose the type of chart to draw, for example, you choose the 2 - D Pie pie chart.
How to draw a pie chart in Excel 2016 Picture 3
Step 3: After you make your selection -> the pie chart style will appear in the Excel spreadsheet.
How to draw a pie chart in Excel 2016 Picture 4
If you want to change the data in the spreadsheet -> when there is a change in the data, the chart will update automatically according to that change. For example, in January I entered the data to increase -> then you can see immediately the pie chart also changes.
How to draw a pie chart in Excel 2016 Picture 5
So, with the 3 steps above, you can successfully draw a pie chart in Excel. Once the chart is created, you can also edit it like:
- Add other components to the chart:
Click on Chart Elements to see more small features:
+ Chart Title : Add a title for the chart.
+ Data Labels : Add data labels for the chart.
+ Legend : Add notes to the chart.
How to draw a pie chart in Excel 2016 Picture 6
- Change color and chart style in Excel
To change the color and shape of the pie chart -> click on the Chart Styles icon as shown below, you can choose the style and color of the chart to best suit.
How to draw a pie chart in Excel 2016 Picture 7
- Use the feature to filter or display data
For example, if you want to obscure the data of the 2 months of February and March, and if you want to show the data of January, you click on Chart Filters -> select the data you want to display. success.
How to draw a pie chart in Excel 2016 Picture 8
Above are tips to help you know how to draw pie charts in Excel version 2016. If you use other versions of Excel such as Excel 2003, 2007, 2010, 2013, please refer to how to create pie charts in Excel. here to see how. Good luck!
You should read it
- How to draw a map chart on Excel
- How to create 2 Excel charts on the same image
- How to draw charts in Excel
- How to draw flow charts in Excel
- Instructions on how to create charts in Excel professional
- How to fix chart position in Excel
- Instructions for using Pareto, Histogram and Waterfall charts in Excel 2016
- Steps to use Pareto chart in Excel
- How to rename data series in Excel chart
- Instructions on how to copy charts from Excel to Word
- Instructions for creating interactive charts in Excel with INDEX function
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
May be interested
How to align printed pages in Excel
How to customize the interface of lectures by Player in iSpring Suite
Download PDFCreator 4.2.0: A tool to create PDF files within seconds
How to fix Google Docs not automatically saving changes
New features are available in PowerPoint 2019
Summary of basic features of Google Docs