Skip to main content

How to show percentage in Pie chart in Excel – A full guide

Author: Siluvia Last Modified: 2024-05-10

In Excel, pie charts are powerful tools for visualizing data distributions, allowing you to quickly grasp the relative importance of different categories at a glance. A common enhancement to these charts is displaying percentages, which can provide clearer insights into the proportions each segment represents. This tutorial will guide you through different methods of adding percentage labels to your pie charts in Excel, enhancing the readability and effectiveness of your data presentations.

Show percentage in pie chart

In this section, we will explore several methods to display percentage in a pie chart in Excel.

By changing the chart styles

Excel offers a variety of built-in chart styles that can be applied to pie charts. These styles can automatically include percentage labels, making this a quick and straightforward option for enhancing your chart's clarity.

  1. Select the pie chart to activate the Chart Tools tab in the Excel ribbon.
  2. Go to the Chart Design tab under Chart Tools, browse through the style options and select one that includes percentage labels.
    Tip: Hovering over a style will give you a live preview of how it will look.

The desired style then applies to your selected pie chart. The percentages should now be visible on your pie chart. See screenshot:

By changing the overall layout of the chart

Changing the overall layout of your pie chart can give you more control over which elements are displayed, including data labels that can be formatted to show percentages.

  1. Select the pie chart for which you want to show percentage.
  2. Go to the Chart Design tab under Chart Tools, click the Quick Layout drop-down list, and then select a layout that includes percentage labels.
    Tip: Hovering over a layout will give you a live preview of how it will look.

The percentages should now be visible on your pie chart. See screenshot:

By adding the Percentage label

For a more direct approach, you can specifically enable and customize percentage labels without altering other chart elements. Please follow the steps below to get it done.

  1. Right click the pie chart that you want to show percentages, and then select Add Data Labels from the context menu.
  2. Now data labels have now been added to the chart. You need to right click on the chart again and choose Format Data Labels from the right-clicking menu.
  3. The Format Data Labels pane is now displayed on the right side of Excel. You then need to tick the Percentage box in the Label Options group.
    Note: Ensure the "Percentage" option is ticked. You can then keep any label options you need. For example, you can also select "Category name" if you want both the name and percentage to appear.

Now percentages are shown in the selected pie chart as shown in the screenshot below.

Note: You can position your labels and modify the font size to make sure your chart remains easy to read.

By following the detailed steps outlined above, you can effectively display percentages in your Excel pie charts, thereby making your data visualizations more informative and impactful. Enhance your reports and presentations by applying these techniques to present data in a more accessible and understandable way. For those eager to delve deeper into Excel's capabilities, our website boasts a wealth of tutorials. Discover more Excel tips and tricks here.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Ok so what I want to do is switch it around, so that my labels show the categories and the legend shows the percentage. is there a way to do that other than re-structuring the table I used to make it?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations