Excel to Pie Chart Converter: How to Make a Pie Chart

Excel has a built-in pie chart converter: select a category column and its values, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel turns the selected range into a chart you can label, format, and save; you do not need a separate conversion website for ordinary spreadsheet data.

What “Excel to pie chart converter” means

The phrase can refer to two different tasks. Most often, someone has categories and numbers in an Excel worksheet and wants to turn them into a pie chart. In that case, the chart command in Excel does the conversion. A separate online converter is generally unnecessary.

Sometimes the request means converting an Excel chart into another format, such as an image or PDF. That is a different operation: first make or open the chart in Excel, then copy or export it in the format a report, presentation, or website needs. The right route depends on whether the source is data or an existing chart.

A pie chart represents each value as a share of a whole. For instance, a table listing 42 units of product A, 33 of product B, and 25 of product C can become a chart showing each product’s proportion of the total. It does not change the underlying worksheet values; it adds a visual summary linked to them.

Prepare the worksheet data

Organize the data as one category column and one numeric column. Put clear headings in the first row, keep each category on its own row, and avoid blank rows within the range. For example, cells A1:B4 might contain “Product” and “Units” as headings, followed by three product names and their quantities.

Use a single, meaningful measure, such as units sold, survey responses, or budget shares.
Make category names distinct enough to identify in a legend or data label.
Check that values are numbers, not text that merely looks like numbers.
Remove totals and subtotals from the selected range. Including a grand total as another slice makes the chart misleading.
Decide how to handle blank, zero, negative, or unknown values before charting.

For a pie chart, the values should be parts of the same whole and normally should be nonnegative. A list of monthly temperatures, for example, is not a good pie-chart dataset because the months are time periods rather than parts of one total. A chart can still be created from unsuitable data, but the visual may suggest a relationship that the numbers do not support.

Create a pie chart in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, select the category labels and their corresponding values, including the headings if you want Excel to use them. Then follow these steps:

Open the Insert tab.
Choose Insert Pie or Doughnut Chart in the Charts group.
Select 2-D Pie for a standard flat pie chart.
Review the chart and check that each slice matches the intended category and value.

If the data is in a continuous table, click a cell in that table and insert the chart; Excel may infer the range. Check the result rather than assuming it selected correctly. If you prefer to choose the range explicitly, drag over the category and value columns before inserting the chart. For non-adjacent ranges, select the first range, then hold Ctrl while selecting the second on Windows.

Excel for Mac has the same general workflow, though ribbon layout and button placement can vary by version and window size. Select the data, use the Insert tab, and choose a pie chart from the chart options. Excel for the web also supports inserting charts, but available controls and formatting options can differ from the Windows desktop application.

Choose a suitable pie-chart design

A standard 2-D pie is usually the clearest choice when there are only a few categories. A 3-D pie can distort the apparent size of slices because of perspective, so it is usually a poor choice when readers need to compare values accurately. Doughnut charts have a hole in the center but otherwise share many of the same limitations as pie charts.

Pie charts become hard to read when there are many small slices or values close in size. As a practical guide, use a pie when there are a handful of categories and the central question is how each category contributes to one total. If the reader must compare many categories or spot small differences, a bar chart is usually clearer. Do not combine unrelated measures just to fit them into one pie.

Consider category order, too. Excel generally plots slices in the order of the source data. Sorting the table from largest to smallest can make the chart easier to scan, but keep any order that has a meaningful purpose, such as a fixed sequence used throughout a report.

Add labels and make the chart readable

Labels help readers interpret slices without repeatedly matching colors to a legend. Select the chart, then use Chart Design > Add Chart Element > Data Labels to choose a label placement. Depending on the layout and Excel version, you can also use the chart’s plus icon to add chart elements. To change which details appear, right-click a data label and choose Format Data Labels.

Useful label details include the category name, the value, or the percentage. Percentages answer “what share of the whole?” while values answer “how much?” Showing both can be helpful when there are only a few slices, but too much label text can make a chart cluttered. A legend may be preferable when category names are long.

Give the chart a descriptive title, such as “Share of Orders by Product,” rather than a generic title like “Chart Title.” Use distinct colors and sufficient contrast. Avoid relying on color alone to communicate a critical distinction: include readable category labels, and consider how the chart will appear when printed in grayscale or viewed by someone with color-vision differences.

Common problems and how to fix them

The chart shows the wrong categories: Select the chart and use Chart Design > Select Data to review the chart data range and category labels. You can also delete the chart and reselect the correct cells.
Excel makes several series or a confusing chart: A pie chart is designed to show one data series. Check that the selected range contains one category column and one value column, not several unrelated measures.
A slice represents the grand total: Exclude total rows from the chart source. The total is already the whole that the slices represent; charting it as a slice double-counts the data.
Some categories disappear or look wrong: Inspect the source for blank cells, text-formatted numbers, zero values, negative numbers, or hidden rows. Correct the data and then check the chart again.
The percentages do not match expectations: Confirm that the selected values are the intended components of the whole and that no extra rows were included. Excel calculates slice shares from the plotted values.
Labels overlap: Show fewer label fields, move labels outside the slices, use a legend, enlarge the chart, or switch to a bar chart.

One common misconception is that changing the chart’s colors or labels changes the source data. It does not. The chart displays the values in the worksheet; edits to those values can update the chart, while formatting affects only how the chart appears.

Update, copy, or export the chart

A chart created from worksheet cells is typically linked to those cells. If you change a source value, the chart updates to reflect the new data. If you add a category outside the original selected range, however, it may not appear automatically unless the source is an expanding Excel table or you adjust the chart data range. Using a table can help keep related data together as rows are added.

To reuse a chart in a report or presentation, select it and copy it into the destination application. Pasting options can vary: a linked chart may update when the workbook changes, while a picture is a fixed snapshot. If the chart must remain visually unchanged, use a picture; if it should reflect updated worksheet values, keep a link and consider whether the recipient will have access to the workbook.

To create a PDF of a worksheet or workbook, use File > Export or File > Save As and select PDF where available. Check print layout and page breaks first, because a chart may be clipped or scaled unexpectedly. Excel’s desktop editions can also copy a chart as a picture through the chart’s copy options; exact options may vary by platform and version. For web publishing, use an appropriate image or document export rather than assuming a native Excel chart will display on every site.

Separate converters, cost, and privacy

For routine chart creation, Excel itself is the most direct option if the workbook is already open there. Microsoft 365 desktop Excel includes chart tools; access to desktop applications and some services depends on the user’s Microsoft plan and organization. Excel for the web may provide a no-cost route for eligible personal or organizational accounts, but features and account terms can change. Check Microsoft’s current product details for exact availability rather than relying on a converter advertisement.

Online file-conversion sites may be useful when the goal is to convert an existing file into a different format and Excel is unavailable. They are not inherently needed to turn cells into a pie chart. Before uploading a workbook, consider whether it contains personal, financial, customer, or company information. Read the service’s privacy and retention terms, and follow workplace rules. A local Excel workflow avoids sending the workbook to an unrelated third-party converter.

Frequently Asked Questions

Can I convert Excel data to a pie chart for free?
Excel’s chart command can create a pie chart from worksheet data. Whether you can use Excel for free depends on the version, account, and access available to you; Excel for the web may be available with an eligible account. Check Microsoft’s current terms for your situation.

How do I convert an Excel spreadsheet to a pie chart online?
Open the workbook in Excel for the web if your account supports it, select the category and value cells, then insert a pie chart from the Insert tab. If using a third-party website, review its privacy terms before uploading sensitive data.

Why is my Excel pie chart showing percentages incorrectly?
Check the selected range for extra rows, totals, or values that do not belong to the same whole. Excel calculates each slice as a proportion of the plotted values, so an incorrect source range produces misleading percentages.

Can a pie chart show more than one data series?
A pie chart is intended to display one data series at a time. If you need to compare multiple groups, consider separate charts or a different chart type, such as a clustered bar or column chart.

How do I save an Excel pie chart as an image?
Select the chart and copy it, then use an appropriate picture-pasting or chart-copy option in the destination application. The exact commands vary by Excel platform and version. For sharing a full page or workbook, exporting to PDF is another option.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.