Guides · Excel
How to make a pie chart in Excel
Excel is the right place for a pie chart that should stay inside the workbook. The steps below match Microsoft 365 and Excel 2021 on Windows and Mac, and they are close in Excel for the web. Names of buttons shift slightly between versions.
Build the chart in the workbook
- Put category names in column A and numbers in column B. One header row is fine. Do not include a totals row in the selection, or the total becomes its own slice.
- Select both columns, including the header.
- Go to Insert, then the pie chart icon, and choose 2-D Pie. Pick 3-D Pie only if you specifically want that look.
- Click the chart. Use Chart Design or the plus icon (Chart Elements) and add Data Labels.
- Right-click a label and choose Format Data Labels. Check Percentage. Uncheck Value if the percent is enough. Category name is optional and gets crowded on small slices.
To save a picture from Excel, right-click the chart and choose Save as Picture, or copy it and paste into a slide. The chart in the sheet remains linked to the cells. The picture does not.
When pasting is shorter
If the goal is a single labeled figure and you are finished with the model, copy the same two columns and paste them into the pie chart maker for Excel. Percentages are calculated from the total, and the download is a PNG or SVG with no watermark. The page does not upload the .xlsx file. Apple Numbers copies the same two-column shape, so the paste works from there too.
Excel can plot a column of numbers that are already percentages. If those numbers sum to about 100, the pie matches them. If you paste raw counts here, the maker divides by the total instead of treating each cell as a finished percent.