The fastest way to make a pie chart

A pie chart is a circular graph divided into slices, where each slice represents a part of a whole. To create one, you enter your data into a spreadsheet, select it, and insert a chart — the software does the rest. The process takes about two minutes and works the same way in Excel, Google Sheets, and Apple Numbers, though the menu names differ slightly.

The key is having your data in the right shape before you start: a list of categories in one column and the numbers that go with them in the next column. If your data is scattered or mixed with other information, spend 30 seconds organizing it first — it saves time and prevents mistakes.

Key Takeaways

  • Pie charts work best when you have fewer than six categories, because too many slices become hard to read and compare.
  • Your data must be in two adjacent columns: category names in one, numbers in the other, with no blank rows between them.
  • After selecting your data, the Insert Chart menu appears in all three programs, and you choose the pie chart type from a list of options.
  • You can change colors, add labels, and move the chart to a different location after it is created without starting over.

Setting up your data before you start

Open your spreadsheet and look at what you have. Your data should sit in two columns side by side, with no blank rows or extra text mixed in. The first column holds the category names (for example: "Rent", "Food", "Utilities", "Other"). The second column holds the numbers that belong to each category.

If your data is spread across the sheet or has headers in a different row, move it now. Select the category names and numbers you want to include, and paste them into a clean area with the categories on the left and numbers on the right. Leave the header row at the top if you have one — the software will recognize it and not count it as data.

Do not include totals or percentages in your data range. The pie chart calculates those automatically. If you have a total row at the bottom, delete it or move it somewhere else before you select your data.

Creating a pie chart in Excel

Click on the first cell of your data (the first category name) and drag to the last number in your range. This selects all the data the chart needs. Make sure you include both the category names and the numbers — if you select only the numbers, Excel will not know what to label each slice.

Go to the Insert menu at the top and look for the Charts button. Click it, and a menu of chart types appears. Find Pie Chart in the list and click it. Excel shows you a few pie chart styles — the standard pie chart (the first one) is what you want for most purposes. Click it, and the chart appears on your sheet.

The chart is now live on your spreadsheet. You can click it to select it, then drag it to move it to a different location. Right-click the chart to change colors, add data labels (the numbers or percentages on each slice), or edit the title.

Creating a pie chart in Google Sheets

Select your data the same way: click the first category name and drag to the last number. Go to the Insert menu and click Chart. Google Sheets opens a chart editor on the right side of the screen.

In the chart editor, look for the Chart Type dropdown at the top. Click it and scroll down to find Pie Chart. Click Pie Chart, and Google Sheets draws the chart on your sheet when ready. You see a preview as you make changes.

The chart editor stays open so you can customize it. Look for options to add a title, change colors, or add labels to the slices. When you are done, click the X to close the editor. The chart stays on your sheet and updates automatically if you change the numbers in your data.

Creating a pie chart in Apple Numbers

Select your data by clicking the first cell and dragging to the last number in your range. Go to the Insert menu and click Chart. A chart appears on your sheet with a panel on the right showing chart options.

In the chart options panel, look for the chart type selector at the top. Click the icon that looks like a pie chart (usually the third or fourth option). Numbers converts your data to a pie chart when ready.

Use the panel on the right to customize the chart. You can change the title, add labels to the slices, and adjust colors. Click outside the chart when you are done editing, and it locks into place on your sheet.

When a pie chart is not the right choice

Pie charts work well when you have three to five categories and want to show how parts add up to a whole. If you have more than six categories, the slices become too thin to read, and the labels crowd together. In that case, a bar chart or column chart is clearer.

Do not use a pie chart to compare values across time — use a line chart or column chart instead. Pie charts also do not work well if one category is much larger than the others, because the small slices become hard to see and label. If that is your situation, consider a bar chart where you can make each bar a different width.

If you are unsure whether a pie chart is right for your data, try creating one and look at it. If the slices are hard to distinguish or the labels overlap, switch to a different chart type. Most spreadsheet software lets you change the chart type without losing your data — just right-click the chart and choose a new type.

Editing and moving your chart after you create it

Once the chart exists, you can move it, resize it, or change how it looks. Click the chart to select it (you see a border around it), then drag it to a new location on the sheet. Drag the corners to make it larger or smaller.

To change the title, double-click the chart to enter edit mode, then click the title text and type a new one. To add labels to the slices (so people can see the actual numbers or percentages), right-click the chart and look for an option like "Add Data Labels" or "Show Values". The exact wording depends on which program you use.

If you change the numbers in your original data, the chart updates automatically. You do not have to recreate it. If you want to add or remove a category, edit your data range, and the chart adjusts to match.

Frequently Asked Questions

Can I make a pie chart with percentages instead of numbers?

Yes. Enter the percentages in your data column instead of the raw numbers, and the pie chart will use them. The software will still draw the slices proportionally. However, if your percentages do not add up to 100, the chart may look odd, so double-check your math first.

How do I change the colors of the pie slices?

Right-click the chart and look for a formatting or color option. In Excel, click "Format Data Series". In Google Sheets, use the Series panel on the right. In Numbers, use the Format panel. You can usually click each slice individually to change its color, or explore a color scheme to the whole chart at once.

What if I want to show one slice separated from the pie?

In most spreadsheet programs, you can click a single slice to select it, then drag it away from the pie. This is called "exploding" a slice and is useful when you want to emphasize one category. Click and drag the slice outward, and it separates from the rest of the chart.

Can I add a legend to my pie chart?

Yes. In Excel and Google Sheets, right-click the chart and look for Legend options. In Numbers, use the Format panel. You can choose where the legend appears (right, bottom, top, or left of the chart) or hide it entirely if the slice labels are clear enough.

How do I delete a pie chart I no longer need?

Click the chart to select it, then press Delete or Backspace. The chart disappears, but your original data stays in place. If you delete it by mistake, press Ctrl+Z (or Command+Z on Mac) to undo.