How to create a pie chart in Excel
Pie charts are a regular way to show things through data, which help your paper be scientific and attract readers. The following article details how to create a pie chart in Excel.
You should first learn how to use a pie chart when:
- Your data is a string.
- There is no 0 or less value in the data table.
- To represent data by circles, you should not use more than 7 data fields on a circle.
How to create a pie chart: For example, with a sales table, draw a pie chart that represents sales.
- Draw a chart:
How to create a pie chart in Excel Picture 1
Step 1: Highlight the data to chart.
How to create a pie chart in Excel Picture 2
Step 2: In INSERT -> select the icon of the pie chart -> choose the type of chart to draw, in this example, select the pie chart 2 - D Pie.
How to create a pie chart in Excel Picture 3
Step 3: After selecting the chart type, the pie chart is drawn as shown:
How to create a pie chart in Excel Picture 4
- In case you want to change the data on a spreadsheet -> the chart updates itself with that change. For example, the North increased its sales to 2026 -> the chart changes.
How to create a pie chart in Excel Picture 5
So with 3 simple steps, you have drawn a pie chart.
- Edit chart:
1. Add other components to the chart:
Click on the CHART ELEMENTS icon with the following properties:
- Add title to the chart: Check Chart Title .
- Add data labels to the chart: Tick Data Labels .
- Add notes to the chart: Select Legend .
How to create a pie chart in Excel Picture 6
2. Change chart colors and styles
To change chart colors and shapes, click on the Chart Styles icon according to your preferences and post requirements, you can choose the chart style and color accordingly.
How to create a pie chart in Excel Picture 7
3. The feature to filter or display the data section need to be emphasized
For example, if you want to obscure the data of the Central and Southern regions, the largest part of the North is visible -> click on the Chart Filters icon -> select the data to be displayed and the data you need. blur.
How to create a pie chart in Excel Picture 8
Above is how to draw a pie chart and how to change the chart after drawing.
Good luck!
You should read it
- How to create a bar chart in Excel
- Steps to use Pareto chart in Excel
- 8 types of Excel charts and when you should use them
- How to create a pie chart in Microsoft Excel
- How to create a frequency chart in Excel
- How to create an effect for an Excel chart in PowerPoint
- How to Create a Multi-Line Chart in Excel
- How to make a thermometer template in Excel
- How to create 2 Excel charts on the same image
- Steps to create graphs (charts) in Excel
- How to create a Gantt chart for project management in Excel
- Create Excel charts that automatically update data with these three simple steps
May be interested
How to check data entered in a cell in Excel
SYD function - Calculate depreciation for an asset by remaining value in Excel
PRICE, PRICEDISC, PRICEMAT - Calculate the value of stock in Excel
IMSUM and IMSUB functions - Sum and complex differences in Excel
TBILLPRICE function - The function calculates the value of treasury bonds by the $ 100 face value in Excel
TBILLYIELD function - The function calculates the discount rate for a bond in treasury in Excel