create pie chart in excel from one column

In the collumn 'rating' are just the numbers 1-5 for the respective raiting. (So i know exactly what presentation got which rating) 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. This is how it looks when i don't do anything with it. If your data isn't in a continuous range, select nonadjacent cells or ranges. Your chart will include all the data in the range.

Do one of the following: If your chart data is in a continuous range of cells, select any cell in that range. I played around with distinct, AddCollumns, GroupBy and some other functions. To create a chart, you need to select at least one cell in a range of data (a set of cells). I've tried a lot so far, but i can't get it to work. (for example 5 People rated it with a 4 -> frequency = 5) The Pie of Pie and Bar of Pie options may not be familiar to all audiences and you’d. From this group, you’ll need to select from 2D, 3D, and Doughnut. From the Insert tab, go to the Charts command group and click the Insert Pie or Doughnut Chart icon. So on the left collumn should be the rating (1-5), and on the right one the frequency. Step 2 - Insert the type of pie chart you want. 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.

Create pie chart in excel from one column