Pie Chart Creator Online in Excel: How to Make One

Yes. In Excel for the web, select a table containing category names and values, then use the Insert tab to add a pie chart. Excel creates the chart from that data; you can then add labels, adjust its appearance, and share the workbook online.

What an online Excel pie chart creator does

Excel for the web is the browser-based version of Microsoft Excel, available through Microsoft 365. It can create and edit charts in a workbook stored online, so a separate chart-making website is not required for a basic pie chart. The chart remains connected to its source cells: when you change a value in the table, the chart updates to reflect the revised data.

A pie chart represents one complete total divided into categories. Each slice corresponds to a category’s share of that total. For instance, if a survey records 40 responses for option A, 35 for B, and 25 for C, the slices represent 40%, 35%, and 25% of the 100 responses. This is most useful when readers need to compare parts of one whole, rather than follow changes over time or compare many separate measures.

Excel is more than a one-click chart generator: you can keep the underlying data, chart, and explanatory notes together in one workbook. That makes it useful for recurring reports, classroom assignments, small-business summaries, and charts that need to be revised later. It is less suitable when the goal is a highly bespoke infographic with extensive illustration or a specific branded layout.

Prepare the data before inserting the chart

A clear source table is the best way to avoid misleading slices. Put one category in each row, with its corresponding number in an adjacent column. Use a descriptive heading for each column, such as Category and Units. For example, a monthly budget table might list Rent, Food, Transport, and Other in the first column, with each category’s spending in the second.

Use one series of nonnegative numbers. A pie chart cannot meaningfully show negative values.
Use category names that are short enough to read in labels or a legend.
Keep the total to a manageable number of categories. Many narrow slices are difficult to compare.
Check that the values represent parts of the same whole and cover the same period or group.
Exclude totals and subtotals from the plotted rows, or Excel may treat them as additional slices and distort the result.

Suppose a shop’s sales by product are 500, 300, and 200 units. The total is 1,000, so the slices represent 50%, 30%, and 20%. These values make a sensible pie chart if they describe the same sales period and the three categories account for all the sales being discussed. If the table instead lists sales for different months, a line chart or column chart is usually more informative because the months are separate observations, not pieces of one total.

Create a pie chart in Excel for the web

Open the workbook in Excel for the web. If starting from scratch, enter category names and values in two adjacent columns, including headers.
Select the category and value cells, including the headers. Selecting only the relevant rows helps prevent unrelated notes or totals from being included.
On the ribbon, open the Insert tab and choose a pie chart from the chart options. If Excel offers chart recommendations, choose a basic two-dimensional pie chart for a standard part-to-whole comparison.
Review the result. Check that the category names and values correspond to the slices, and that no blank rows, totals, or unintended columns were picked up.
Select the chart to reveal chart-related controls. Use the available options to add a title, show data labels, change the chart style, or reposition the legend.

The exact arrangement of chart controls can vary as Microsoft updates Excel for the web. If a formatting choice is not available in the browser, open the workbook in the desktop Excel app and make the change there. The workbook can still be saved to OneDrive or SharePoint and reopened in a browser. If the range is formatted as an Excel table, adding rows to that table can also make it easier to maintain the source data; check that the chart includes any new rows you add.

Make the slices and labels easy to understand

A chart should explain itself without forcing readers to guess what a color means. Give it a specific title, such as Product sales by units in October, rather than a generic title such as Pie Chart. If the categories are already labeled directly on the slices, a legend may be unnecessary. If the chart is small or labels would overlap, a legend can be easier to read.

Data labels can show category names, values, percentages, or a combination. Percentages are often useful when the question is about each category’s share; raw values are useful when readers also need the underlying quantity. Avoid showing too many label fields at once. A label crowded with a name, value, and percentage can become harder to scan than a simple legend.

In desktop Excel for Microsoft 365 on Windows, select the chart and use Chart Design > Add Chart Element > Data Labels to choose a label position. You can also right-click a label and choose Format Data Labels to adjust which details appear. On Mac, select the chart and use the Chart Design tab’s chart element controls; the wording and placement can vary slightly by Excel release. Excel for the web provides chart formatting controls when the chart is selected, but may not expose every desktop option.

Use colors that distinguish the slices without implying a meaning that the data does not support. A larger slice should not be the only cue for importance if the chart’s colors suggest a ranking or status system. If accessibility matters, check that labels or a legend identify the categories as well as color does. A reader who cannot distinguish particular colors should still be able to understand the chart.

When a pie chart is the right choice

Pie charts work best with a small set of categories that make up a meaningful whole, such as a breakdown of survey answers or a department’s share of total costs. They become less effective as the number of categories grows, especially when several values are similar. Readers generally find it easier to compare lengths in a bar chart than to estimate small differences between wedge angles.

Consider a breakdown with 12 product types. A pie may produce many tiny slices and labels that collide. A horizontal bar chart can show all 12 categories more clearly and makes it easier to rank them. If the main question is how a category changes from month to month, use a line or column chart instead. If there are two or more independent series, a pie chart usually cannot show the comparison clearly because each pie represents only one series at a time.

Do not use a pie chart simply because the data is expressed as percentages. Percentages may describe independent rates that do not sum to 100%, such as the percentage of customers who use different services when people can use more than one. Those figures are not slices of one whole. A bar chart is generally a clearer way to compare them.

Common problems and how to fix them

The chart includes an unwanted slice: Check the selected range for a total row, blank category, or stray value. Select the intended category and value cells again, or adjust the chart’s source range in desktop Excel.
Category names appear as numbers or are missing: Confirm that the name column was included in the selection and that the data is arranged with categories in one column and values in the next.
Labels overlap: Reduce the number of categories, move detail to the legend, show fewer label fields, or use a bar chart. Shrinking the chart often makes the problem worse.
The slice proportions seem wrong: Check for values stored as text, negative entries, duplicated rows, or values from inconsistent periods. Make sure the chart is showing the intended data series.
The chart does not change as expected: Verify that you edited a cell included in the chart’s source data. If you added rows outside the original range, expand the range or use a table-based source and confirm the new rows are included.

One frequent misconception is that entering percentage values automatically makes any dataset suitable for a pie chart. The percentages still need to describe parts of one whole. Also, if the values sum to something other than 100 because of rounding, the chart can still show their relative shares; the displayed slice percentages may be calculated from the total of the values rather than match the rounded figures in the source.

Excel for the web, desktop Excel, and other tools

Excel for the web is convenient when you want to create a chart in a browser, collaborate on a cloud-stored workbook, or make straightforward formatting changes without installing the desktop app. Desktop Excel for Microsoft 365 on Windows offers a fuller set of chart formatting and data-management controls. Mac users have desktop Excel too, though some ribbon details and available features can differ from Windows. In either desktop version, the basic route is to select the data and choose Insert > Insert Pie or Doughnut Chart, then select a pie style.

For a simple chart, the browser and desktop versions can both be enough. If you need detailed label settings, a specialized layout, or a particular export workflow, check that the feature is available in your version before building the final report. A chart created in desktop Excel can generally be viewed in Excel for the web, but some advanced formatting may not be editable in the browser.

Other online chart makers can be useful when you need a designed graphic for a presentation or a website and do not need a spreadsheet workbook as the main deliverable. Compare their import and export options, privacy terms, and whether they require an account. If you already maintain your figures in Excel, making the chart there avoids transferring data to another service and keeps the chart connected to its source cells.

Cost, sharing, and data privacy

Excel for the web is available through Microsoft’s online services, but access and features depend on the account and Microsoft 365 plan. Some users can work with Excel for the web at no additional cost with a Microsoft account, while organizations may provide access through a workplace or school subscription. Plan details can change, so check Microsoft’s current product information rather than assuming every chart feature is included with every account.

To collaborate, save the workbook to OneDrive or SharePoint and use Excel’s sharing controls to invite people or create a link, subject to the sharing settings set by the account owner or organization. A link can grant viewing or editing access, so check its permissions before sending it. Avoid uploading confidential figures to an unfamiliar chart site; review the provider’s privacy and retention terms, particularly for customer, health, financial, or workplace data.

Frequently Asked Questions

Can I make a pie chart online in Excel for free?

Excel for the web may be available at no additional cost with a Microsoft account, but access and features depend on current Microsoft account and plan terms. Check the current Microsoft offering if you need a specific chart-formatting feature.

How do I add percentages to an Excel pie chart?

Select the chart and turn on data labels using its chart controls. In desktop Excel for Windows, use Chart Design > Add Chart Element > Data Labels, then format the labels to show percentages. In Excel for the web, select the chart and look for label options; some detailed settings may require desktop Excel.

Why does my pie chart show the total as a slice?

The total row is probably part of the selected source range. Re-select the category rows and their values without the total, then update or recreate the chart. A total is a summary of the slices, not another category in the whole.

Can a pie chart show more than one data series?

A standard pie chart represents one data series at a time. If you need to compare several groups or periods, use a bar, column, or line chart, depending on whether the comparison is between categories or across time.

Can I download or share the chart?

You can share the workbook through OneDrive or SharePoint using Excel’s sharing controls. If you need a standalone image, desktop Excel offers chart-copying and export options that depend on the workflow and version; check the available options in your copy of Excel. Sharing the workbook preserves the link between the chart and its data.

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.