In the Series Name field, write “Score” or select the cell C1 (the one that contains the name/label of your dataset) in the Series Values field, select the dataset (range C2:C17) and click OK. and the same dialog box ( Select Data Source) that you met when entering data for the line chart appears.
An empty chart area shows up, on which you have to right-click to get the contextual menu. The “less easy way” consists in clicking on the same button without having selected data. Note that due to the high number of items, the legend takes a lot of space, thus reducing readability… You may need to tune the chart using options brought up by the icon +. By selecting the first pie icon that shows up, you will automatically get a colorful pie chart named Score (after the data label found in C1). The “easy way” consists in selecting both columns (labels included, range B1:C17) and clicking on Insert Pie or Doughnut Chart in the section Charts of the ribbon under the Insert menu. In the same way that line charts were made previously, there is an “easy way” and a “less easy way” to create a pie chart. (Note that those values have been rounded and that the total is actually equal to 99,9%). Here is the list of the represented parties and their final score expressed in %.
#How to make a pie chart in excel 2016 how to#
Let’s learn how to make pie charts by using a “local” example: the local elections in Bergen in 2015 (Bergen Kommune, Kommunestyrevalg 2015). It is not so often that one gets to use a pie chart… and it is not so often that such a chart is used for the right purpose. Pie charts can be used to represent different categories of a population, polls, data referring on proportions and percentage. In Excel16 -3- Figures and graphs / MS Excel 2016 (EN)
0 kommentar(er)
