partymop.blogg.se - How to make a pie chart in excel with names

HOW TO MAKE A PIE CHART IN EXCEL WITH NAMES HOW TO
HOW TO MAKE A PIE CHART IN EXCEL WITH NAMES SERIES

Here, I selected B4:D10.Īfter that, a dialog box named Create PivotChart will appear.

Firstly, select the data range for the Pie Chart.

Here, I will make a Pie Chart with this dataset. It contains the Sales of 2 States in different Departments. I have taken the following dataset to explain this method.

HOW TO MAKE A PIE CHART IN EXCEL WITH NAMES HOW TO

In this method, I will explain how to use Pivot Chart to make a Pie Chart in Excel with multiple data. Inserting Pivot Chart to Make a Pie Chart in Excel with Multiple Data You can also Filter the Pie Chart by following Step-05 from method-1 if you want.ģ. In the following picture, you can see my final Pie Chart.

After that, add the Percentage to the Pie Chart by following the procedure from Step-04 of method-1.įinally, you will get your desired Pie Chart.

Then, format the Pie Chart by following the procedure from Step-03 of method-1.

Next, add Legend and Data Labels by following the procedure from Step-02 of method-1.

Here, I changed mine to the Average Number of Present Students.

After that, change the Chart Title by selecting the marked portion in the following picture.

Now, you will see a Pie Chart with your selected data inserted into the Excel sheet.

Secondly, click on the Quick Analysis button.

Firstly, select the data range you want to insert in the Pie Chart.

In this method, I will explain how to make a Pie Chart in Excel by employing the Quick Analysis feature. Employing Quick Analysis Feature to Make a Pie Chart in Excel Read More: How to Explode Pie Chart in Excel (2 Easy Methods)Ģ. In the following picture, you can see how my final Pie Chart looks. Now, you will see you have got your desired Exploded Pie Chart.

Now, increase the Pie Explosion according to your preference.

HOW TO MAKE A PIE CHART IN EXCEL WITH NAMES SERIES

Here, I will explain how you can Explode a Pie Chart in Excel.Īfter that, the Format Data Series task pane will appear on the right side of the screen. Now, you will see that you have Filtered your pie chart as you wanted. After that, select the fields you want to show in your Pie Chart.In this step, I will show you how you can Filter your Pie Chart. Read More: How to Show Percentage in Excel Pie Chart (3 Ways)

In the following picture, you can see that the Data Labels are looking more clear than before. Here, I selected the marked Glow Variation. After that, select the Glow Variation you want.Then, select the drop-down option for Presets.

After that, select the color you want for your text.

Thirdly, select the drop-down option for Color.

Secondly, select the Text Fill and Outline tab.

Now, the Format Data Labels task Pane will appear on the right side of the screen. Here, I will format the Data Labels to give them more clear look. 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