What a pie chart does and when to use one

A pie chart is a circle divided into slices, where each slice represents a part of a whole. The size of each slice shows what percentage or proportion that item makes up. Pie charts work best when you have fewer than six categories and want to show how parts add up to 100 percent — like budget breakdown, market share, or survey responses where one answer per person is the rule.

If your data has many categories, changes over time, or compares amounts that don't add to a total, a bar chart or line chart usually tells the story better. But when you need to show "what portion of the whole is this," a pie chart is the clearest choice.

Key Takeaways

  • Organize your data in two columns: category names in one column and the numbers that represent each slice in the next column.
  • In Excel, Google Sheets, or Word, select your data, then use the Insert menu to add a chart and choose the pie chart type.
  • The software automatically calculates percentages and draws the slices proportional to your numbers.
  • You can add a title, change colors, add labels showing percentages or category names, and move the chart to a different location on your page.

Organize your data before you start

Pie charts need data in a specific shape. Put your category names in one column and the numbers for each category in the column next to it. For example, if you are tracking how you spend your monthly budget, one column might say "Rent," "Food," "Transportation," and "Entertainment," while the next column shows the dollar amounts for each.

Make sure your numbers add up to something meaningful — usually a total of 100 percent or a dollar amount that represents your whole budget. If some numbers are zero or negative, the chart will not display correctly. Delete or combine any categories with zero values before you create the chart.

Do not include a total row in your data. The software will treat it as another slice, which makes the pie add up to more than 100 percent.

Create a pie chart in Excel

Open your spreadsheet and select the two columns that hold your category names and numbers. Click and drag from the first cell to the last cell that contains data. Make sure you include the header row (the row with "Category" and "Amount" or whatever you called them).

Go to the Insert tab at the top of the screen. Click the Chart button. A menu will open showing different chart types. Look for Pie and click it. Excel will show you pie chart options — the first one (a standard pie chart) is what most people need. Click it, and Excel will place the chart on your spreadsheet.

The chart appears with a default title and no labels on the slices. Right-click the chart to open the menu, then click Add Chart Element to add a title, data labels (percentages or category names), or a legend. You can drag the chart to move it or resize it by dragging the corners.

Create a pie chart in Google Sheets

Select your two columns of data the same way: click the first cell and drag to the last cell with data, including headers. Go to the Insert menu at the top and click Chart. Google Sheets opens the chart editor on the right side of the screen.

Under Chart type, scroll down and click Pie chart. Google Sheets draws the chart and shows it on your spreadsheet. The chart editor panel stays open on the right so you can make changes.

To add a title, look for the Chart & axis titles section in the editor and type your title in the box. To add labels showing percentages or category names on each slice, click the Series tab in the editor, then turn on Data labels. You can choose whether to show category names, percentages, or both. When you are done, click outside the chart or close the editor panel.

Create a pie chart in Word

Word does not create charts from data you already have — instead, it inserts a chart with sample data that you then replace. Go to the Insert tab and click Chart. A dialog box opens asking what type of chart you want. Click Pie and then OK.

Word opens a small Excel spreadsheet window with sample data. Replace the category names and numbers with your own data. The pie chart on your document updates as you type. When you are finished entering data, close the Excel window by clicking the X button.

To edit the chart title, colors, or labels, right-click the chart in your Word document and choose Edit Chart. This opens the Excel window again so you can make changes. You can also right-click and choose Chart Title to add or change the title directly.

Customize colors, labels, and appearance

By default, the software assigns colors to each slice. To change them, right-click a slice and look for a color or formatting option. In Excel, you can right-click a slice and choose Format Data Point. In Google Sheets, use the Series tab in the chart editor to change individual slice colors.

Labels on the slices can show category names, percentages, or both. In Excel, right-click the chart, click Add Chart Element, then Data Labels, and choose what you want to display. In Google Sheets, use the Series tab and turn on Data labels, then pick the label type from the dropdown menu.

If your chart has many categories and the labels overlap or look crowded, consider adding a legend instead of labels on the slices. A legend is a box that lists each category and its color, placed outside the pie. All three programs let you add or remove a legend through the chart editing options.

Move, resize, and save your chart

Once your chart is complete, you can move it anywhere on your page. Click the chart once to select it (you will see a border around it), then drag it to a new location. To resize it, click and drag one of the corner handles outward to make it larger or inward to make it smaller.

In Excel and Google Sheets, the chart is part of your spreadsheet file, so it saves automatically when you save the file. In Word, the chart is embedded in your document and saves with it. If you need to use the chart in another program, you can right-click it and choose Copy, then paste it into another document or presentation.

Frequently Asked Questions

Can I make a pie chart if my numbers don't add up to 100?

Yes. The software calculates the percentage each number represents of the total and draws the slices accordingly. Your numbers can be dollars, hours, survey responses, or any other unit — as long as they represent parts of a meaningful whole, the chart will display correctly.

What if I want to highlight one slice by pulling it out from the pie?

In Excel and Google Sheets, click the chart, then click the specific slice you want to separate. Drag it away from the center. In Word, right-click the chart, click Edit Chart, then click and drag the slice. This is called "exploding" a slice and works best when you want to emphasize one category.

How do I change the chart type after I create it?

In Excel, right-click the chart and click Change Chart Type. In Google Sheets, open the chart editor and click Chart type to pick a different type. In Word, right-click the chart, click Edit Chart, then use the chart type options. Your data stays the same — only the visual format changes.

Can I add a title to my pie chart?

Yes. In Excel, right-click the chart and click Add Chart Element, then Chart Title. In Google Sheets, use the chart editor's Chart & axis titles section. In Word, right-click the chart and choose Chart Title. Type a title that describes what the pie chart shows.

What should I do if one category is too small to see on the chart?

If a slice is very small, consider combining it with other small categories into an "Other" category. Alternatively, add data labels showing percentages so readers can see the exact value even if the slice is tiny. Some people also use a legend instead of labels to make small slices easier to identify.