How to make pie chart with percentages

Table of Contents Show

Pie Chart Constructor
Display percentage values on pie chart in a paginated report (Report Builder)
In this article
To display percentage values as labels on a pie chart
To display percentage values in the legend of a pie chart
How do you create a pie chart with percentages?
How do you make a pie chart in Excel with percentages?
What is 20% in a pie chart?

This Pie Chart constructor converts raw data to percentages to create a circular statistical graphic divided into proportional slices or sectors. The arc length of each slice is proportional to the quantity it represents.

Enter your raw or percentage data in the calculator below. Click the 'Calculate' followed by 'Create Pie Chart' buttons and your pie chart will open in a new window. A menu appears above the chart offering several options, including downloading an image. Hover over the sectors to display the data.

Pie Chart Constructor

Data Presentation: Pie Charts

A pie chart displays a set of categories’ proportions, or percentages of the total, in a visual way. To accurately create a pie chart, you must first work out the percentage of the pie chart that each category should occupy. From there, you can calculate the angle that each piece of the pie should have.

Compile your data into categories. Assign each category a number. For example, if you have statistics on four categories of university majors, you might wish to turn that data into a pie chart. You might find the following: there are 410 art majors, 420 science majors, 900 language majors, and 540 engineering majors.

Add all the numbers together to get the total. In this case:

410 + 420 + 900 + 540 = 2270

Divide each of the categories by the total. You results will be a list of decimals under 0. Round, if necessary. In the example, with rounding:

\text{Art: } 410 ÷ 2270 = 0.18 \\ \text{Science: } 420 ÷ 2270 = 0.18 \\ \text{Language: } 900 ÷ 2270 = 0.40 \\ \text{Engineering: } 540 ÷ 2270 = 0.24 \\

Multiply each of the decimals by 100 to get the percentages. You can easily do this by moving the decimal point two places to the right. In the example:

Art: 18 percent

Science: 18 percent

Language: 40 percent

Engineering: 24 percent.

These percentages will be the labels for each section.

Multiply the decimals from Step 3 by 360 to get the number of degrees each slice of pie should take up in the pie chart. For the example, this yields the angles 64.8, 64.8, 144 and 86.4 for the categories of art, science, language and engineering, respectively.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Display percentage values on pie chart in a paginated report (Report Builder)

Article
10/18/2021
2 minutes to read

To display percentage values as labels on a pie chart

Add a pie chart to your report. For more information, see Add a Chart to a Report (Report Builder and SSRS).
On the design surface, right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.
On the design surface, right-click on the labels and select Series Label Properties. The Series Label Properties dialog box appears.
Type #PERCENT for the Label data option.
(Optional) To specify how many decimal places the label shows, type "#PERCENT{Pn}" where n is the number of decimal places to display. For example, to display no decimal places, type "#PERCENT{P0}".

To display percentage values in the legend of a pie chart

On the design surface, right-click on the pie chart and select Series Properties. The Series Properties dialog box displays.
In Legend, type #PERCENT for the Custom legend text property.