When you have finished, close the spreadsheet. In the spreadsheet that appears, replace the default data with your own information. For help deciding which chart is best for your data, see Available chart types. Add Data Labels Click on the chart Click the + Sign in the top right Select Data Labels Change to Percentage This will show the Values of the data labels. Click the chart type, and then double-click the chart you want. Sometimes it is helpful to add percentages so that the end user can easily see what percentage each quarter makes up. You could do the same to the other categories, of course, by extending what I've started for you here. As you can see, the pie chart is made by using percentages of the total. Notice that two of the sections are colored: for windows pass (solid red) and windows fail (gradient red). Divide each segments value by the total, to get the corresponding percentage. It will produce the pie chart shown here as long as you put the data in A1:F2. How do I calculate the pie chart Find the total of all values in the dataset.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |