How to Create and Format a Pie Chart in Excel

Visualize your data by exploding a slice of the pie

What to Know

  • Select the data and go to Insert > Insert Pie Chart > select chart type.
  • After adding a pie chart, you can add a chart title, add data labels, and change colors.

This article explains how to make a pie chart in Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010.

Enter and Select the Tutorial Data

A pie chart is a visual representation of data and is used to display the amounts of several categories relative to the total value of all categories. Pie charts are used, for example, to show the production of one factory in relation to the output of the company or to show the revenue generated by one product relative to the sales of the entire product line.

Before you create a pie chart, enter the chart data. Then, highlight the data you want to use in the pie chart.

Screenshot of worksheet data

To follow along with this tutorial, enter the data shown in the image above into a blank worksheet.

Create the Basic Pie Chart

The basic pie chart is a plain, unformatted chart that displays the categories of data, a legend, and a default chart title.

To create a pie chart, highlight the data in cells A3 to B6 and follow these directions:

  1. On the ribbon, go to the Insert tab.

    Screenshot of Insert tab
  2. Select Insert Pie Chart to display the available pie chart types.

    Screenshot of Insert Pie Chart menu
  3. Hover over a chart type to read a description of the chart and to preview the pie chart.

    Screenshot of pie chart description
  4. Choose a chart type. For example, choose 3-D Pie to add a three-dimensional pie chart to the worksheet.

Add the Chart Title

Edit the default chart title to add a more suitable one.

  1. Select the default chart title. A box appears around the title.

  2. Click on the text to put Excel in edit mode and place the cursor inside the title box.

    Screenshot of Chart Title in Edit mode
  3. Press Delete or Backspace to delete the existing text.

  4. Type a chart title. For example, type The Cookie Shop 2018 Revenue from Sales.

    Screenshot of edited chart title
  5. To separate the title into two lines, place the cursor between two words and press Enter. For example, place the cursor between 2018 and Revenue.

Add Data Labels to the Pie Chart

There are many different parts to a chart in Excel, such as the plot area that contains the pie chart representing the selected data series, the legend, and the chart title and labels. All these parts are separate objects, and each can be formatted separately. To tell Excel which part of the chart you want to format, select it.

If you don't get the desired results, the right part of the chart was not selected. A common mistake is selecting the plot area in the center of the chart when the intention is to select the entire chart. The easiest way to select the entire chart is to select a corner of the chart.

If you make a mistake, use the Excel undo feature to remove the mistake. Then, select the right part of the chart and try again.

To add data labels to a pie chart:

  1. Select the plot area of the pie chart.

  2. Right-click the chart.

    Screenshot of right-click menu
  3. Select Add Data Labels.

    Screenshot of Add Data Labels
  4. Select Add Data Labels. In this example, the sales for each cookie is added to the slices of the pie chart.

Change Colors

When a chart is created in Excel, or whenever an existing chart is selected, two additional tabs are added to the ribbon. These Chart Tools tabs, Design and Format, contain formatting and layout options specifically for charts.

To change the color of the slices, background, or text:

  1. Select an area on the chart background to select the entire pie chart.

    Screenshot of Design tab
  2. To change the color of the pie chart slices, go to Chart Tools Design and select Change Colors.

    Screenshot of Change Colors
  3. Hover over a row of colors to preview the color in the pie chart.

  4. Choose a color. The pie slices change to varying shades of the selected color.

    Screenshot of Change Colors options
  5. To change the background color of the pie chart, go to the Chart Tools Format tab.

    Screenshot of Format tab
  6. Select Shape Fill.

    Screenshot of Shape Fills list
  7. Choose a color.

    Screenshot of Shape Fill to change background color
  8. To add a gradient to the background color, select Shape Fill.

  9. Select Gradient.

  10. Choose a gradient style.

    Screenshot of Gradient options
  11. To change the color of the text in the title and data labels, select the Text Fill dropdown arrow.

    Screenshot of Text Fill
  12. Choose a color.

Explode a Piece of the Pie Chart

When you want to add emphasis to a slice of the pie, drag or explode the slice from the rest of the pie. After a slide is exploded, the rest of the pie chart shrinks so that the chart area stays the same size.

Resizing a chart may move the data labels outside the pie slices. Drag a data label to reposition it inside a slice.

To explode a slice of a pie chart:

  1. Select the plot area of the pie chart.

  2. Select a slice of the pie chart to surround the slice with small blue highlight dots.

    Screenshot of "Lemon" slice of pie chart
  3. Drag the slice away from the pie chart to explode it.

    Screenshot of exploded pie chart
  4. To reposition a data label, select the data label to select all data labels.

  5. Select the data label you want to move and drag it to the desired location.

FAQ
  • How do I make a pie chart in Excel with percentages?

    Right-click the pie chart and select Series Label Properties, then type #PERCENT into the "Label data" option. To change the Legend values to percentages, right-click the pie chart and select Series properties > Legend > type #PERCENT in the "Custom legend text" field.

  • How do I make a bar chart in Excel?

    To make a bar chart in Excel, select the cells you want to use in the chart (along with Labels, Values, and Headers) > Insert > select Bar Charts dropdown under "Charts." Then select More Column Charts > Bar in the left-hand pane > choose a chart type > OK.

  • How do I make a Gantt chart in Excel?

    Select the cells with the data you want to use for the chart, then select Insert > Insert Bar Chart > Stacked Bar. Next, select the first bit of data in the chart > Format > Shape Fill > No Fill > hold Ctrl and select the vertical axis. Under "Axis Position" select Format Axis > Categories in reverse order.

Was this page helpful?