To create a pie chart from one column in Excel for Microsoft 365 on Windows, select the numeric cells, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel makes a slice for each number, but it uses default category labels; add a separate column of names if you want the slices identified by meaningful labels.
What a one-column pie chart shows
A pie chart represents one data series as parts of a whole. Each value becomes a slice, and the slice’s size reflects its share of the sum of all the values. For example, the values 12, 8, and 5 add up to 25. Their shares are 48%, 32%, and 20%, respectively. Excel can calculate and display those percentages as data labels.
A single column is enough when you only need to chart values and do not mind generic category names. It is not enough to tell Excel what each slice represents unless the categories are already available as labels elsewhere. With values in A2:A4, Excel may show the points as categories 1, 2, and 3. That is workable for a quick visual, but it is not ideal for a chart that someone else needs to understand.
Pie charts are intended for nonnegative values that make up a meaningful total. They are most useful when there are only a few categories and the differences are easy to see. A pie chart does not show change over time or compare several different totals well.
Prepare the data in one column
Put the values in a continuous range, with one value per row. A heading at the top is helpful because Excel can use it as the series name. For example, enter Quantity in A1, then 12, 8, and 5 in A2:A4. Select the heading and the values together. If your values have no heading, select only the numeric cells.
Before inserting the chart, check that the cells contain numbers rather than number-like text. Numbers stored as text may not behave as expected in a chart. Also review the data for blank rows, accidental totals, or values that should not be part of the whole. A total row should not normally be included alongside the values it totals: doing so counts the same data twice and changes every slice’s share.
- Use one row per category or item.
- Keep the values in a single uninterrupted range where possible.
- Exclude a grand-total row unless it is itself a genuine category.
- Use zero only when a category truly has no amount to contribute; a zero has no visible slice.
Create the chart in Excel for Windows
- Select the numeric range, including its heading if it has one. For the example above, select A1:A4.
- On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
- Under 2-D Pie, choose the standard Pie option. Excel inserts a chart on the worksheet.
- Click the chart title and type a descriptive title, such as Units by Category. If the title is not shown, use Chart Design > Add Chart Element > Chart Title.
- Add labels if you want viewers to see values or percentages directly on the slices. The options are described below.
If the Insert tab shows chart choices in a different layout, look for the pie-chart icon in the Charts group; the available ribbon layout can vary with the Excel window size. The chart type to choose is 2-D Pie. A 3-D pie is available, but perspective can make slice sizes harder to compare accurately.
On Excel for Mac, select the range and use the Insert tab to choose the pie chart type from the chart options. The ribbon arrangement can differ from Windows, but the same basic process applies: select the cells, insert a 2-D pie, and then use the chart design and formatting controls to add labels. Excel for the web also supports inserting charts, though some design and formatting controls may be arranged differently or be more limited than in the desktop app.
Add meaningful category names
For a chart that people can interpret without guessing, place category names next to the values. For example, enter Snacks, Drinks, and Fruit in A2:A4 and the matching values 12, 8, and 5 in B2:B4. Select both columns, including their headings, before inserting the pie chart. Excel uses the first column for category labels and the second for the slice values.
If the chart already exists and the names are in another range, you can connect that range without rebuilding the chart. Select the chart, choose Chart Design > Select Data, and use the Horizontal (Category) Axis Labels area to edit the label range. Select the cells containing the category names and confirm. The wording in the Select Data Source dialog can differ slightly depending on the chart and Excel build.
When you have only one column of values, another option is to keep the chart and display the value or percentage on each slice, then use a legend with manually supplied names only if you can assign the names correctly. Do not assume Excel can infer labels from the meaning of numbers. If you need named categories, a neighboring label column is the clearest and least error-prone data layout.
Show values, percentages, or both
Click the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position such as Center or Outside End. To choose exactly what appears, right-click a data label and choose Format Data Labels. In the formatting pane, enable options such as Category Name, Value, or Percentage. You can show more than one item, but too many labels can make a small chart crowded.
For the example values 12, 8, and 5, the total is 25. Percentage labels should therefore read 48%, 32%, and 20%. If the chart is based on a one-column range without category names, turning on Category Name may still give generic labels such as 1, 2, and 3. Adding a label column is the better fix if those numbers do not help readers identify the slices.
Use values when the exact amounts matter, percentages when the relative share matters, and category names when readers need to know what each slice means. A legend can identify categories, but labels placed on the chart may be easier to follow when there are only a few slices. If labels overlap, try a different label position, enlarge the chart, or remove information that is not essential.
Make the pie chart easier to read
Give the chart a title that describes the measure and the group being compared. A title such as Monthly support requests by type is more informative than Pie Chart. Keep category names concise and use consistent units. If the source values are counts, do not label them as dollars or percentages.
Use color to distinguish categories, not to imply an unsupported ranking. Excel assigns colors automatically, and you can change a slice by selecting it and using the formatting controls. If the chart will be printed or viewed by people with color-vision differences, do not rely on color alone: keep a legend or category labels visible, and choose colors with enough contrast.
Avoid exploding many slices or using 3-D effects as decoration. These effects can make the chart look more dramatic while making the proportions less straightforward to compare. If a category is so small that its label cannot fit, consider showing its name and percentage in a legend or choosing a bar chart instead.
Common problems and fixes
- The chart has slices labeled 1, 2, and 3. That is normal when Excel has values but no category labels. Add a names column and select it with the values, or update the category label range through Chart Design > Select Data.
- Excel includes the heading as a slice. Check the selected range. Include a text heading with the data when possible; if you selected an unintended cell, correct the range through Chart Design > Select Data.
- The chart looks wrong because one slice dominates. Check for an accidental total, a misplaced value, or categories measured on different bases. A pie chart compares each value with the sum, so even one unusually large number can overwhelm the other slices.
- Some slices are hard to see. A zero has no visible size, and very small values can be difficult to distinguish. Confirm the source data, then consider a bar chart if the small categories need to be compared.
- There are negative values. A pie chart is not a suitable way to represent negative contributions to a whole. Verify the data and choose a chart type that can show positive and negative amounts meaningfully.
When another chart is a better choice
Use a pie chart when the categories are parts of one whole, the values are mutually exclusive, and there are only a few slices. If categories overlap, if the values do not share a meaningful total, or if you need to compare several groups, the pie can give a misleading impression even when Excel draws it correctly.
A bar or column chart is often clearer for comparing exact amounts, especially with many categories or values that are close together. A line chart is generally more useful for a trend across dates. If you want a pie chart but have many small categories, grouping minor categories can help only when that grouping is legitimate and clearly named; it should not hide distinctions that matter.
Frequently Asked Questions
Can I make a pie chart with only one column in Excel?
Yes. Select the numeric cells and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel can chart the values, but without category labels it may use generic labels such as 1, 2, and 3.
Does a pie chart need a total row?
No. Excel calculates each slice’s share from the selected values. Including a total row with the individual values usually counts the same amounts twice, so leave it out unless it represents a separate category.
How do I show percentages on the slices?
Select the chart and add data labels through Chart Design > Add Chart Element > Data Labels. Then use Format Data Labels to turn on Percentage. Check that the selected source range contains only the values you intend to include.
Why does Excel show numbers instead of category names?
The chart has no category-name range, so Excel uses default point labels. Add a column of names beside the values and select both columns, or edit the category label range in Chart Design > Select Data.
Can a pie chart show negative values?
A pie chart is designed to show nonnegative parts of a whole, not gains and losses. Check the data and choose a bar or column chart if negative amounts are meaningful to the comparison.
Related
- Change Text to Numbers in Excel: Easy, Reliable Methods
- Center Across Selection in Excel: Add It to Quick Access
- Change Block Capitals to Lowercase in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Edit Legend in Excel Line Charts: Names, Position, and StyleTo edit a legend in an Excel line chart, select the chart and go to Chart Design >…
- Power Pivot Column Formatting: Set Formats That StickIn Excel for Microsoft 365 on Windows, open the Power Pivot window, select the column, then choose a…
- Excel Pie Chart: Count Occurrences for Each CategoryYes. To make an Excel pie chart count occurrences, first summarize how many times each category appears, then…
- Gantt Chart Template in Excel: Build a Project PlanTo make a Gantt chart template in Excel, list each task with a start date and finish date,…
- Excel Clustered Bar Chart Error Bars: How to Add and FormatTo add error bars to a clustered bar chart in Excel for Microsoft 365 on Windows, select the…
- How to Embed an Excel Chart in PowerPoint and Edit ItTo embed an Excel chart in PowerPoint, select the chart in Excel, copy it, then in PowerPoint choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.