how to filter data and create pie chart in excel

In the Quick Analysis, you will find many options to analyze your data. Now select the cells A3 to B8 and right-click on your mouse and press on to Quick Analysis. Here we will be analyzing the attendance list of 5 months of some students in a course. In this example, we will see the process of inserting data from a table to make a pie chart. The first condition of making a pie chart in Excel is to make a table of data. blur.Ībove is how to draw a pie chart and how to change the chart after drawing.Related Articles How to Insert Data into a Pie Chart in Excel The feature to filter or display the data section need to be emphasizedįor 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. 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.ģ. Add data labels to the chart: Tick Data Labels. Add title to the chart: Check Chart Title. Add other components to the chart:Ĭlick on the CHART ELEMENTS icon with the following properties: So with 3 simple steps, you have drawn a pie chart. For example, the North increased its sales to 2026 -> the chart changes. In case you want to change the data on a spreadsheet -> the chart updates itself with that change. Step 3: After selecting the chart type, the pie chart is drawn as shown: 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: For example, with a sales table, draw a pie chart that represents sales. To represent data by circles, you should not use more than 7 data fields on a circle. There is no 0 or less value in the data table. You should first learn how to use a pie chart when: The following article details 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.

How to filter data and create pie chart in excel