These different chart options are visible when you click the pie button in the Charts group on the ribbon. Step 2: Select the data that you want to include in the pie chart.Įxcel offers a handful of various 2D pie chart options, as well as a 3D pie chart option and a doughnut chart option. In my example below I am going to be displaying a pie chart that includes a column of months, and a column of the total sales for that month. One column with a label, and one column with data that will be displayed as the appropriately sized pieces of the pie. For the optimal display of data in a pie chart, it’s ideal to have two columns. This guide will assume that you already have data in a spreadsheet, and that you wish to display that data as a pie chart. The steps in this article were performed in Microsoft Excel 2013. How to Create a Pie Chart in Excel (Guide with Pictures) Our create table in Excel tutorial can show you how to do this. Our article continues below with additional information on making a piechart in Excel, including pictures of these steps.Īnother thing you can do with your spreadsheet data is turn it into a table. I used plotly.4 Additional Sources How to Make Excel 2013 Pie Charts It automatically calculates the total and pourcentage even if you add more categories. Percentage (%) = 100 x partial value / total value I calculate the percentage by adding the values of all the category present in the table and using this formula (you can see it in the script.js file):
In this example, I use a Json file to get the data from the embedded spreadsheet, so I can use it in my javascript code and create a bar chart. Here is a working code I have written for you: Javascript is a powerful language offering a lot of useful data visualization libraries like plotly.js.
But if you want to keep your data as it is, there is a solution by using some javascript. You can do this with a pivot table and add a line with the pourcentage for each category like brettdj showed in his answer.
0 kommentar(er)
