How to Make a Percentage Chart in Excel (With Labels)

To make a percentage chart in Excel, select your category labels and percentage values, then choose a chart such as a column chart or pie chart from the Insert tab. If you have counts rather than percentages, calculate each category’s share of the total first. Format the values as percentages and add clear labels so readers can see what each part represents.

The right setup depends on what you mean by a percentage chart. Use a pie or doughnut chart to show how categories divide a whole, and a bar or column chart to compare percentages such as completion rates. The steps below cover both, using Excel for Microsoft 365 on Windows.

What You’ll Need

An Excel worksheet with category names and either percentage values or the counts that make up a total.
A clear definition of the whole. For example, decide whether a category’s percentage is its share of all responses or its completion rate against a target.
Excel for Microsoft 365 on Windows. The main chart features are also available in recent desktop versions and Excel for the web, though ribbon layout can differ slightly.

Step-by-Step

Arrange the source data in columns. Put category names in one column and their values in the next, with one category per row and a descriptive heading at the top. For example, use A1 for Category, B1 for Responses, then list Product A, Product B, and Product C in A2:A4 with counts in B2:B4. Keep the data in a simple rectangular range: avoid blank rows or merged cells within it. Clear labels make the chart easier to interpret and help Excel recognize which column contains categories.
Decide whether you need to calculate percentages. If your source already contains valid percentage values, such as 0.72 for a 72% completion rate, you can chart those values directly. If you have counts and want each one’s share of a total, add a third column headed Share. With categories in A2:A4 and counts in B2:B4, enter this in C2: =B2/SUM($B$2:$B$4). If the counts are 42, 33, and 25, the total is 100 and the first result is 42/100, or 42%. Copy the formula down through C4; the results should be 42%, 33%, and 25%. The dollar signs keep the total range fixed as you fill the formula down.
Format the values as percentages. Select the calculated shares or existing decimal values. On the Home tab, in the Number group, select Percent Style. If you need a specific number of decimal places, use Increase Decimal or Decrease Decimal in the same group. Excel stores 42% as 0.42, so formatting changes how the value appears without changing the underlying calculation. If you type 42 into a cell and apply Percent Style, Excel may show 4200%; enter 42% or 0.42 for a value of 42%.
Select the correct range for your chart. For a chart that compares calculated shares, select the category names and Share values, including their headings—for example, A1:A4 and C1:C4. To select separate ranges, select the first range, then hold Ctrl while selecting the second. For a pie chart showing each category’s share of the whole, you can instead select the category names and original counts in A1:B4. Excel calculates each slice’s proportion from those counts when you turn on percentage labels. Do not include a grand-total row as another category, because that would distort the proportions.
Insert a chart that fits the message. With the relevant ranges selected, open the Insert tab. For a share-of-whole display, choose Insert Pie or Doughnut Chart and select a 2-D Pie or Doughnut option. For comparing percentages across several groups, choose Insert Column or Bar Chart and select a 2-D option such as Clustered Column or Clustered Bar. Pie charts work best with a small number of categories whose values make up one whole. Bar and column charts are usually easier to compare when there are many categories or when the percentages do not add up to 100%.
Add a descriptive chart title. Select the chart, then choose Chart Design > Add Chart Element > Chart Title > Above Chart. Click the title area and replace the placeholder with a specific description, such as Share of Survey Responses or Tasks Completed by Team. If the chart already has a title placeholder, you can click it and type directly. A clear title tells readers what the percentage refers to; a title that says only Percentages leaves the measure and population unclear.
Show percentage labels on a pie or doughnut chart. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position such as Best Fit or Outside End. Right-click one of the labels and choose Format Data Labels to open the formatting pane. Under Label Options, select Percentage. Clear Value if you want the labels to show percentages only; leave Category Name selected if you also want each slice identified. Check a few labels against the data. If you charted the raw counts, Excel calculates each slice’s percentage from the total of the plotted values.
Format a bar or column chart to display percentages. If the source values are already percentages, the value axis may already use an appropriate format. If it shows decimals such as 0.42, right-click the value axis and choose Format Axis. In the pane, expand Number and select Percentage, then set the decimal places you want. To show the value on each bar, choose Chart Design > Add Chart Element > Data Labels and select a position. Data labels use the number format of the source cells in many cases; if they display decimals or too many digits, format the source cells as percentages and check Format Data Labels for number-format options. For values in the Share column, 0.42 should display as 42%, not 0.42%.
Review the chart before sharing it. Confirm that every category is present, the labels match the intended measure, and the percentages are plausible. For a share-of-whole chart, the percentages should total about 100%; small differences can occur when displayed values are rounded. For a completion-rate chart, values do not have to total 100%, because each percentage describes a separate rate. Resize the chart so labels are readable, and remove unnecessary legend entries or gridlines if they make the result harder to scan.

Common Mistakes

Charting whole numbers as if they were decimal percentages. A cell containing 42 means forty-two, not 42%. Applying percentage formatting makes it display as 4200%. Enter 42% or 0.42 when the intended value is 42%.

Using the wrong kind of percentage. A category share divides each category by a common total, while a completion rate compares progress with a target. A pie chart is misleading for separate rates that do not form a single whole. Use bars or columns to compare independent percentages.

Including a total in the plotted categories. If the individual counts are 42, 33, and 25, adding a Total row of 100 to the pie chart makes Excel treat 100 as another slice. Select only the individual categories and their values.

Assuming the displayed percentages must always add to exactly 100%. Rounded labels can add to 99% or 101% even when the underlying data totals 100%. Increase decimal places to check, or explain that labels are rounded.

Choosing a pie chart for too many categories. Many thin slices and labels are difficult to read. Combine genuinely minor categories only when that grouping is meaningful, or use a sorted bar chart so comparisons remain visible.

Tips

Choose a chart based on the question. Use a pie or doughnut chart for parts of one whole, a bar chart for ranking categories, and a column chart for comparing a small number of groups.
Keep the percentage scale consistent when comparing multiple charts. A bar chart with an axis that runs from 0% to 100% may communicate differences differently from one whose axis is narrowly truncated.
Use one or two decimal places only when that precision helps. For broad proportions, whole percentages are often easier to read; for rates close together, one decimal place may be useful.
Sort bar-chart source data by percentage if the main purpose is to show a ranking. The chart updates with the worksheet data, so keep the category and value rows together when sorting.
Use labels and a useful title rather than relying on color alone. This improves readability for people viewing the chart in grayscale or with color-vision differences.
If you expect the data range to grow, consider converting the source range to an Excel table with Insert > Table before building the chart. A chart based on a table can include new rows as the table expands, though check the chart after adding data to ensure the intended series are included.

Troubleshooting

The chart shows decimals instead of percentages: For an axis, right-click the axis, choose Format Axis, expand Number, and select Percentage. For a pie chart, open Format Data Labels and select Percentage. For a column or bar chart’s data labels, format the source percentage cells and check the label number format. Make sure the source values are decimals such as 0.42; a stored value of 42 will format as 4200%.

The pie slices or percentages look wrong: Check that you selected the intended categories and values, and exclude any total row. If percentages should represent shares, confirm that the values use the same unit and that the denominator is the sum of those categories. Blank cells, negative numbers, or values from a different measure can make the chart confusing; correct the source before adjusting the chart.

Excel plots categories as separate series, or the labels are missing: Select the chart and choose Chart Design > Switch Row/Column if Excel has interpreted the rows and columns in the wrong direction. To add labels, use Chart Design > Add Chart Element > Data Labels, then open Format Data Labels and choose the label options you need. If a chart has no useful category names, return to the worksheet and confirm the labels are included in the selected range.

The labels overlap or disappear: Make the chart larger, reduce the number of decimal places, or choose a different label position through Chart Design > Add Chart Element > Data Labels. For a crowded pie chart, use a bar chart instead. You can also select fewer label components—for example, show the category name in a legend and the percentage on the slice rather than repeating both in every label.

The menu names do not match: These paths describe Excel for Microsoft 365 on Windows. In Excel for Mac, the chart and formatting controls are available from the Chart Design tab and the chart’s formatting pane, though their placement can vary by release. Excel for the web also supports common chart types, titles, and labels, but some detailed formatting controls may be limited; open the workbook in the desktop app if a setting is unavailable.

Frequently Asked Questions

How do I show percentages on an Excel pie chart?
Select the chart, choose Chart Design > Add Chart Element > Data Labels, then open Format Data Labels and select Percentage under Label Options. Clear Value if you want percentages without the original counts.

How do I make a chart show 0% to 100%?
For a bar or column chart, right-click the value axis and choose Format Axis. Set the axis bounds to 0 and 1 if your source values are stored as decimals, then set Number to Percentage. If the values are whole numbers from 0 to 100, use bounds of 0 and 100 and format the axis as a number with a percent sign only if the data itself is scaled appropriately; otherwise the labels can be misleading.

Can percentages add up to more than 100%?
Yes, when the values are independent rates, such as the percentage of people completing each of several tasks. They should not exceed 100% if they are mutually exclusive shares of one whole calculated using the same total, except for small differences caused by rounding displayed labels.

Should I use a pie chart or a bar chart for percentages?
Use a pie chart when a few categories divide one whole and the goal is to show each share. Use a bar or column chart to compare rates, rank many categories, or show values that do not represent parts of a single total.

Why does Excel show 4200% instead of 42%?
The cell probably contains 42 as a whole number. Percentage formatting treats 1 as 100%, so 42 displays as 4200%. Replace it with 42% or 0.42, then format the cell as a percentage.

Can I update the chart when the percentages change?
Yes. A chart linked to worksheet cells updates when those cells change. If you add categories, expand the chart’s source data range or use an Excel table as the source, then confirm the new categories appear correctly.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.