how to create pie chart in excel from a worksheet

Now, you will see that Percentage is added to your Pie Chart. Here, I will explain how you can add Percentage to your Pie Chart.Īfter that, the Format Data Labels task pane will appear on the right side of the screen. Read More: How to Edit Pie Chart in Excel (All Possible Modifications) In the following picture, you can see how my Pie Chart looks after formatting it.

After that, select the Color Palette you want for your chart.

Now, I will change the color of the Pie Chart. Here, I selected Style 7.įinally, you can see that I have changed the Chart Style to my desired style.

After that, select the Chat Style you want for your chart.

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 from a worksheet