![]() You can do this using the formula =ROUND(num,0) for each of your calculated percentages. The sum of these values is now 99 instead of 96 as in your original, which results in a better graph: Click on Chart Type Drop-down> Scroll it done and see on charts section where you find Pie Select one of the Chart>Pie Chart will be created. Click the paintbrush icon on the right side of the chart and change the color scheme of the pie chart. The above steps would instantly add a Pie chart on your worksheet (as shown below). ![]() ![]() Click on the Pie icon (within 2-D Pie icons). In the Charts group, click on the ‘Insert Pie or Doughnut Chart’ icon. Click the + button on the right side of the chart and click the check box next to Data Labels. Once you have the data in place, below are the steps to create a Pie chart in Excel: Select the entire dataset Click the Insert tab. It just so happened that the compensations were made on numbers that should be the same.Īnother possible option would be to round your percentage results: Name Val % Rounded % Click the legend at the bottom and press Delete. The problem is caused by your actual percentages being: Name Val %Īs you can see these numbers can't be exactly represented as a (whole number) percentage, the compensations have to be made somewhere. ![]() While not the ideal solution, if you right click on one of the labels and press the Format Data Labels option, you can change the Number display type to percentage, this will increase the number of decimal places in the percentage shown but give you the accurate result asked for. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |