how to make a pie chart in excel with names

In the collumn 'rating' are just the numbers 1-5 for the respective raiting. (So i know exactly what presentation got which rating) Now, increase the Pie Explosion according to your preference. After that, the Format Data Series task pane will appear on the right side of the screen. As you can see it just takes the value of the number and adjusts the size accordingly.Īs you can see I have an ID_presentation collumn that refers to another Excel sheet filled with presentations that can be rated. Here, I will explain how you can Explode a Pie Chart in Excel. This is how it looks when i don't do anything with it. I played around with distinct, AddCollumns, GroupBy and some other functions. I've tried a lot so far, but i can't get it to work. Then click Data Labels and select what kind of data label you want.

Step 2: The Format Data Labels pane opens. (for example 5 People rated it with a 4 -> frequency = 5) Click on the floating plus icon (Chart Elements) beside the chart to add data labels. The steps to add percentages to the Pie Chart are: Step 1: Click on the Pie Chart > click the ‘ + ’ icon > check/tick the Data Labels checkbox in the Chart Element box > select the Data Labels right arrow > select the More Options, as shown below. So on the left collumn should be the rating (1-5), and on the right one the frequency.

So what i wanna do now, is to create a new collumn with the AddCollumns-Function where I count the frequency of the respective rating. The collumn has just ratings from 1-5 (from a star-rating-system). I have an Excel Sheet as Data-Source, and I wanna make a pie-chart diagram out of one collumn that is in this Excel Sheet.

How to make a pie chart in excel with names