In this 3rd step, I will explain how you can format your Pie Chart in Excel. Now, I will add the Data Label to the Pie Chart in Excel.Īfter that, you will see that you have added the Data Labels to your Pie Chart. Here, you will see that the Legends are shown at the bottom of the chart.

Now, select the Legend Position you want for your chart.

To begin with, I will add the Legend.Īfter that, you will see that you have added Legend to your chart.Īfter that, the Format Legend task pane will appear on the right side of the screen. Now, I will explain how you can add Legend and Data Labels to your Pie Chart. Step-02: Adding Legend and Data Labels to Pie Chart Here, I selected Pie from 2-D Pie.įinally, you will see that a Pie Chart with your selected data has been inserted into the Excel Sheet.

Then, select the type of Pie Chart you want.

Thirdly, select Insert Pie or Doughnut Chart from the Charts group.Īfter that, a drop-down menu will appear.

Firstly, select the data range with which you want to make the Pie Chart.

In this step, I will show you how you can insert the Pie Chart. Using Charts Group to Make a Pie Chart in Excelįor this method, I will use the Charts group to make a Pie Chart in Excel. I will make a Pie Chart using this dataset.ġ. This dataset contains the Course Name and Average Number of Present Students in 6 Months. To explain this article, I have taken the following dataset.

The first condition of making a Pie Chart in Excel is to make a table of data.

5 Simple Ways to Make a Pie Chart in Excel

How to create pie chart in excel 2016