create pie chart excel showing percentages

In the menu in the subgroup of 'TEXT OPTIONS' you can use the tool 'Text direction' to change the direction of the signatures in the subgroup of 'Vertical alignment'. 'Best Fit' - option allows Excel to set the signature optimally.When you select this diagram option pie will be slightly smaller but smaller data improves readability 'Outside End' - a signature will appear on the outside of the circle.'Inside End' - the signature will appear from the inside circumference.'Center' - the signature will be displayed at the center of the segments.And so on.ĭefault settings allow you to change the place of signatures on the chart. Set '0.00%' if you need two characters after the decimal point. Put the '0.0%' in the “Format Code” field if you want to display percentages with a single decimal place. Remove the decimal digits and set the format code '0%'. In the 'NUMBER' subgroup change the common format on percentage. In the menu in the subgroup of 'LABEL OPTIONS' you need to uncheck the 'Value' and put the checkmark on 'Percentage'. Once again right click on the chart and select the item 'Format Data Labels': The values from the second column of the table will be on the parts of the circle: In the dialog box select a task 'Add Data Labels'. Now we show the percentage of taxes in the diagram. On the 'INSERT' tab in the 'Charts' group choose a simple “Pie”.ĭiagram appears on the sheet after clicking on the tabs of the selected type of the form:Ī separate segment of the circle is the share of each tax in the total revenues of the consolidated budget in 2015. Select the entire table including the names of the columns. For example take an official tax analyst 'Income tax types in the consolidated budget for 2015': We construct a pie chart with the percentage assignment. Let us consider in detail how to make an Interest chart in Excel.

But there are might be some difficulties without working skills in Excel when you have lack of experience. For example, what percentage of the plan is made, how many goods sold, which part of the students coped with the task, what percentage of employees has a college education, etc. For the sake of clarity it is necessary to show the relative values of the data. He needs to display the information on the chart.

Suppose the user has data in absolute values. Percent charts in Excel: creation instruction

Create pie chart excel showing percentages