To make a pie chart in Excel, select a numeric column and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. For a chart that explains what each slice represents, include a neighboring column of category names as well as the numbers; otherwise Excel may label the slices with row numbers.
Prepare the data before charting
A pie chart compares parts of one whole. Each row should therefore describe one category and have a nonnegative numeric value for that category. For example, a small table might list Apples, Pears, and Oranges in A2:A4, with 12, 8, and 5 in B2:B4. Select the category names and values together, including the column headings if present. Excel can then use the names as slice labels and the values to size the slices.
Arrange the data in a simple rectangular range with one category per row and one series of values. Use a clear heading such as Fruit and Quantity in the first row, and avoid blank rows or merged cells inside the range. Check that the quantities are actually numbers: values stored as text, error values, and empty cells can lead to missing or unexpected slices.
- Use categories that do not overlap. For example, do not count the same sale in both Online and Retail if the chart is meant to show each sale channel’s share.
- Choose one measure and one period, such as units sold by product this month. Mixing dollars and units does not make a meaningful whole.
- Keep the number of categories manageable. A long list of tiny slices is hard to compare and label.
What Excel does with a single column
The phrase make a pie chart from a column can mean two different things. If the column contains numbers such as 12, 8, and 5, Excel can use them as the slice sizes. With no accompanying category column, it may assign generic labels such as 1, 2, and 3, based on the rows. The chart is technically valid, but readers will not know what those slices mean unless you replace the labels or add category names.
If your one column contains text such as Apples, Pears, and Apples, it is not a list of slice sizes. Excel cannot infer that you want to count repeated entries. First summarize the text into category names and counts, for instance with a PivotTable, and then chart that summary. If each text item is already a unique category but you have no numeric measure, decide what value should define each part before making a pie chart; assigning equal values would show category count, not an underlying quantity.
Create the pie chart in Excel for Microsoft 365
- Place category names in one column and their numeric values in the next. Include headers if the range has them.
- Select the complete data range, such as A1:B4. Include headings and all rows, but do not select totals unless the total is itself a genuine category.
- Open the Insert tab on the ribbon, select Insert Pie or Doughnut Chart, and choose 2-D Pie.
- Excel inserts a chart on the worksheet. Drag its border to move it, or use the corner handles to resize it. Click the chart title to replace the default title with a description, such as Fruit sold in June.
On Windows, the chart-specific Chart Design and Format tabs appear when the chart is selected. On Mac, use the Insert tab to insert the chart and the chart tabs or formatting controls that appear after selection; ribbon placement and some dialog details can differ slightly. Excel for the web has chart insertion and basic formatting too, although its controls may be arranged differently from the Windows desktop ribbon.
If the chart puts categories in the wrong direction or treats a heading as data, select the chart and use Chart Design > Switch Row/Column or Chart Design > Select Data to inspect the source range. These controls are useful when the table is arranged horizontally or Excel guesses incorrectly about the headers.
Add category names, values, and percentages
A pie chart is easier to read when its slices are identified directly. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position. To control what the labels show, choose More Data Label Options. In the Format Data Labels pane, you can select items such as Category Name, Value, or Percentage, depending on what is useful for the chart.
For the fruit example, values of 12, 8, and 5 total 25. The slices represent 48%, 32%, and 20% respectively, because each value is divided by 25. If you show percentages, Excel calculates each share from the values included in the chart; the displayed figures may be rounded, so rounded labels can add to 99% or 101% even when the underlying shares total 100%.
Usually, category names plus percentages are enough when the main question is share of the whole. Show raw values as well when readers need the exact counts. Avoid crowding the chart with long names and several numbers on every slice. You can instead place labels outside the slices, use a legend, or shorten the category names in the source table. A legend is less helpful when many colors are similar or the slices are very small.
Make the chart clear and honest
A pie chart works best when the categories form one complete whole and the reader needs to compare their proportions. It is less effective for exact comparisons between similarly sized categories because people judge angles and areas less precisely than aligned bar lengths. If the purpose is to compare values rather than emphasize shares, a bar or column chart is often clearer.
Use a descriptive title and restrained styling. Excel offers 2-D, 3-D, and other pie variations, but 3-D perspective can distort the apparent size of slices. A plain 2-D pie is generally easier to interpret. Colors should distinguish categories without implying an order that the data do not have. Do not rely on color alone if the chart may be printed in grayscale or viewed by someone with color-vision differences; direct labels help.
Check whether a total row has been included by mistake. If the categories add up to 25 and a Total row of 25 is also plotted, Excel treats that total as another slice. It will make the whole chart represent 50, not the intended 25, and distort every category’s share. Select category rows only; keep totals outside the chart range unless the total is genuinely one of the categories.
Update the source and handle repeated categories
If you add more rows after creating a chart, the chart may not include them when its source is a fixed cell range. One convenient approach is to convert the data range to an Excel table with Insert > Table, confirm the range and headers, and create the chart from the table. A chart based on a table can include rows added to that table, which helps keep a growing list in sync. Review the chart source if a new category does not appear as expected.
For repeated records, summarize first rather than plotting every row as an independent slice. For example, if a transaction log has many entries labeled Apples and Pears, use Insert > PivotTable to summarize the records by product and count or sum the appropriate field. Then select the summarized category-and-value results and insert a pie chart. For sales amounts, sum the sales by product; for a survey list where each row is one response, count responses. The aggregation must match the question being asked.
Keep a pie chart to one data series. If you select several numeric columns, Excel may create an unexpected chart or include multiple series. A pie is designed to display one series at a time. To compare the same categories across months or regions, use a different chart type, or create separate pies only when each one represents a clearly defined whole and comparison remains readable.
Common problems and fixes
- The chart has numbers instead of names: Select both the category and value columns before insertion. Alternatively, right-click the chart and choose Select Data to set the category labels to the name cells.
- There is only one slice: Check that the selected range contains multiple numeric values and that Excel is not reading the values as text. Also check that the selection did not include just a total.
- A text-only column makes a strange chart: Text labels alone do not provide slice sizes. Summarize or count the labels and chart the resulting numeric values.
- Some categories are missing: Review the selected data range for blank rows, text-formatted numbers, errors, or rows left outside the source range. Use Chart Design > Select Data to confirm which cells are included.
- The percentages look wrong: Check for a total row included as a slice, duplicate categories that should have been combined, or values outside the intended period. Confirm that the chosen numbers represent parts of the same whole.
When to choose another chart
Use a pie when there are a few mutually exclusive categories and the whole is meaningful—for example, the share of a monthly budget across housing, food, transport, and other spending. For a time trend, such as monthly sales, use a line chart because time order matters. For comparing sales among many products, a bar chart makes it easier to rank categories and read close values. A stacked bar can show composition across several groups while preserving easier comparisons than multiple pies.
There is no universal category limit, but readability falls quickly when labels overlap or many slices are tiny. Combining small categories into Other is reasonable only if the grouping is explained and does not hide a distinction readers need. Keep the detailed table available when precise values or a full category breakdown matter.
Frequently Asked Questions
Can I make a pie chart from just one column in Excel? Yes, if the column contains numeric values. Excel can size slices from those numbers, but without a separate category column the labels may be generic. Add names beside the values for a chart readers can interpret.
How do I make a pie chart from names in one column? Names alone do not tell Excel how large each slice should be. Summarize repeated names into categories and counts, or attach a meaningful numeric measure to each category, then chart the summary.
How do I show percentages on an Excel pie chart? Select the chart and use Chart Design > Add Chart Element > Data Labels, then open More Data Label Options and select Percentage. You can also show category names or values in the same pane.
Can a pie chart include a total row? Usually it should not. The total is the sum of the parts, not another part. Including it makes Excel count that total as an additional slice and changes the proportions.
Why does my Excel pie chart show the wrong categories? The selected range may omit the label column, include a total or blank row, or be interpreted in the wrong orientation. Check the source through Chart Design > Select Data and confirm that category labels and numeric values point to the intended cells.
Related
- Microsoft Excel Invoice Template: Find and Customize
- Excel: Insert a Checkbox Without the Developer Tab
- Excel Insert Image Based on Cell Value: How It Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make an Org Chart in ExcelThe easiest way to make an org chart in Excel for Microsoft 365 on Windows is to use…
- Excel Line Chart: Hide Zero Values Without Losing DataTo hide zero values in an Excel line chart without changing your original data, create a helper column…
- Excel Pivot Table Rows and Filters: How They WorkIn an Excel PivotTable, the Rows area determines which categories appear down the left side, while the Filters…
- Excel Histogram Frequency Table: How to Make OneAn Excel histogram frequency table shows how many numeric values fall within each interval, or bin. In Microsoft…
- Excel Pivot Chart Show Zero Values? Fixes That WorkYes. An Excel PivotChart can show zero values, but the right fix depends on whether the PivotTable contains…
- Bar Chart in Excel: How to Create and Format OneTo make a bar chart in Excel for Microsoft 365 on Windows, arrange category names in one column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.