How To Make Pie Chart In Excel

Oct 27, 2020 • edited Oct 30, 2020

How To Make Pie Chart In Excel

Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.

To create a pie chart of the 2017 data series, execute the following steps.

1. Select the range A1:D2.

Select Data Series in Excel

2. On the Insert tab, in the Charts group, click the Pie symbol.

Insert Pie Chart

3. Click Pie.

Click Pie


Pie Chart in Excel

4. Click on the pie to select the whole pie. Click on a slice to drag it away from the center.


Exploded Slice

Note: only if you have numeric labels, empty cell A1 before you create the pie chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically creates the correct chart. After creating the chart, you can enter the text Year into cell A1 if you like.

#Tutorial#How To#Data Analysis#Charts

How to Delete Duplicates in Excel

How To Use Number and Text Filters In Excel