![]() At first, we have to prepare a dataset containing monthly total sales in different months as shown below. ![]() You can do this using the formula =ROUND(num,0) for each of your calculated percentages. Step 1: Prepare Dataset Here, we will demonstrate how to make a pie chart. The sum of these values is now 99 instead of 96 as in your original, which results in a better graph: 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 % 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. Here, we will use the TEXT function along with the ampersand to create the Legend. Through this chart, we can easily show the percentage in legend. 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. Now, we are going to insert a pie chart for our dataset.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |