• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Pie Chart in Excel

March 1, 2021 by Andrew Childress

Pie charts in Excel help to show you the relative size of parts in your data. Let's learn how to make a pie chart in Excel.

A Pie chart in Excel helps to show you the relative size of parts in your data. It’s easy to see how much share each part of your data has when you use a pie chart. Let’s learn to create them.

Prepare Your Data for Pie Charts in Excel

Before we build a pie chart in Excel, we need to capture and arrange our data. Pie charts work best with data in two columns.

In this example, I’m going to show my team’s sales for the month. Create a list with names in one column, and sales amounts in the second column.

Data for pie chart

Create The Pie Chart in Excel

Now, let’s insert the pie chart. Highlight the data in both columns, then use Excel’s Insert section on the ribbon. Find the selection labeled Charts, and click on the Pie Chart icon.

You’ll see multiple pie chart styles to choose from. Try them each out, but for my example, I’m going to use the 2-D Pie preset that you see below.

2D pie chart Excel

Edit Your Pie Chart

Let’s take our simple pie chart in Excel to the next level. Let’s start by adding data labels to the slices on our pie chart in Excel. This shows you the numeric values from your data, right on top of the pie chart.

Add data labels Excel

One last tweak: let’s change these amounts to percentages instead of the original numeric values. Pie charts are used to show relative proportions, so this is a common tweak you might make.

Right-click on the data labels, then choose Format Data Labels. You’ll see a new menu pop up on the right side of Excel. Tick the Percentage box. Optionally, untick the Value box to show only the percentage of each slice.

percentages pie chart

Pie Chart Pro Tips

Keep in mind these tips for using pie charts in Excel like a pro:

  • Limit the number of categories of data in a pie chart. With too many parts, the pie chart becomes unreadable.
  • Use contrasting colors in the pie chart so that each part is distinct and separate.
  • Pie charts aren’t a good choice if your data includes a negative value (a bar chart might be a better choice.)
Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Hide columns in ExcelUnhide Columns in Excel
Next Post:Show Formulas in ExcelFormulas show formulas Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top