How to Combine Pie Charts in Excel: A Practical Guide

Charts & pivot tables · Updated November 20, 2026

To combine pie charts in Excel into one chart, first combine their source data into a single list of categories and totals, then select that list and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. A standard pie chart displays one data series, so Excel will not simply merge two existing pie charts into a single pie. If your goal is to compare groups, keep separate pies or use a different chart type.

Before you start, decide what “combine” means for your data: adding matching categories together for one overall breakdown, showing a few selected small slices together, or comparing two groups. The best method depends on that choice. The steps below are for Microsoft Excel for Microsoft 365 on Windows; Mac and web differences are noted where they matter.

What You’ll Need

  • An Excel workbook containing the category names and values used in the existing pie charts, or access to the underlying data.
  • A clear decision about whether matching categories should be summed into one total or displayed as separate groups.
  • For a readable pie chart, a modest number of categories with nonnegative values. Consider a bar or column chart if there are many categories or you need precise comparisons.

Step-by-Step

  1. Identify the result you want. If you need one pie showing the overall distribution across categories, combine corresponding values first. For example, if separate charts show fruit sales at two locations, the combined pie should have one slice for Apples, one for Pears, and one for Cherries, with each slice representing the two locations’ total for that fruit. If you need to compare the locations, do not add their values together; the total would hide the difference between them. Use separate charts or a bar chart instead.
  2. Put the source data into a consistent layout. Use one row per category and one column per group, with headers. For example, enter Category, East, and West in A1:C1. Enter Apples, Pears, and Cherries in A2:A4, East values 40, 30, and 10 in B2:B4, and West values 25, 20, and 15 in C2:C4. Keep labels consistent: “Apple” and “Apples” will be treated as different categories unless you standardize them. Remove blank rows within the data and check that the values are numeric rather than numbers stored as text.
  3. Create a combined total for each category. Add a column called Combined in D1. Add the two group values for each category: D2 should total East and West Apples, D3 should total the Pears values, and D4 should total the Cherries values. You can type the totals directly or use a formula. With East values in B2:B4 and West values in C2:C4, enter =SUM(B2:C2) in D2 and fill it down through D4. In this example the results are 65, 50, and 25, for a total of 140. If there are more group columns, expand the range to include them. Check that every row represents the same category across the group columns before adding.
  4. Select only the categories and combined totals. Select A1:A4, then hold Ctrl on Windows and select D1:D4. This non-adjacent selection tells Excel to use the category labels with the combined values, not the original group columns. If the data is in adjacent columns, select the category and total columns together instead. On a Mac, use Command rather than Ctrl for a non-adjacent selection. If selecting separate ranges is awkward, copy the category names and combined totals into two adjacent columns and select that small summary table.
  5. Insert the new pie chart. Choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Excel creates a chart from the selected labels and values. If Excel puts the category names in the chart as values, or uses the wrong range, click the chart and choose Chart Design > Select Data. Check the Chart data range and the Horizontal (Category) Axis Labels, and correct the selections. On Excel for Mac, the same chart and data-selection controls are available on the ribbon, although the layout can differ slightly. Excel for the web also supports inserting pie charts, but some chart-formatting controls may be more limited than in the desktop app.
  6. Add labels that make the chart understandable. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position such as Best Fit. To show category names or percentages, right-click a data label and select Format Data Labels. In the pane, choose the items you want, such as Category Name, Value, or Percentage. Percentage is calculated from the total of the values shown in this pie. For the example, the slices are about 46.4% Apples, 35.7% Pears, and 17.9% Cherries. Avoid showing too many label elements at once if they overlap.
  7. Give the chart a useful title and check the result. Select the title and replace the placeholder with something specific, such as “Combined Fruit Sales by Location.” Check that the legend or labels identify the categories, that the slice sizes match the totals, and that the chart includes the intended rows only. If the chart will be shared, add a note near it explaining which groups were combined and what period the values cover. This avoids suggesting that the pie is a comparison between groups when it actually shows their combined total.
  8. If you meant to combine small slices, use a Pie of Pie chart instead. This is different from adding two complete pies together. Select one category-and-value table, then choose Insert > Insert Pie or Doughnut Chart > Pie of Pie. Excel moves some slices into a secondary pie and represents them as one combined slice in the main pie. Right-click the chart and choose Format Data Series to adjust how the secondary pie is split, such as by position, value, or percentage threshold. Use this option when the smaller categories are important but too crowded to label clearly; it does not combine separate datasets into one overall total.

Common Mistakes

  • Selecting two chart objects and expecting one pie. Selecting or grouping two existing charts can move them together, but it does not merge their data. Build a summary table from the source values and insert a new chart when you need one set of slices.
  • Adding unlike values. Only combine categories that measure the same thing over compatible units and time periods. Adding monthly revenue to yearly quantities, for example, does not create a meaningful pie. Confirm that each input uses the same currency, measurement, and reporting period.
  • Including both group columns and the combined column. If the chart selection includes East, West, and Combined, the chart can show duplicated or misleading information. Select only the category labels and the single total column intended for the pie.
  • Expecting multiple pie series in one standard pie. A standard Excel pie chart plots one series. Selecting two value columns may cause Excel to choose one series or interpret the selection unexpectedly; it does not create a dependable two-group comparison. Use separate pies or a chart designed to compare values.
  • Using too many categories or negative values. A pie chart becomes hard to read when slices are numerous or very similar. Negative values also do not make sense as parts of a whole. Group minor categories only when that aggregation is meaningful, or switch to a bar chart.

Tips

  • Keep an untouched copy of the original data. Put combined totals in a new column or a separate summary sheet. You can then revise the calculation without losing the original values or the ability to compare each group.
  • Use a PivotTable for many categories or groups. Arrange the source data in a long format with columns such as Location, Category, and Sales, then choose Insert > PivotTable. Place Category in Rows and Sales in Values, and make sure the Values field is summarized by Sum. Select the resulting category totals to insert a pie chart. This is useful when the data grows or needs filtering by location or date.
  • Use a Table for data that changes. Select the source range and choose Insert > Table before adding new rows. Tables make expanding source data easier to manage, though you should still verify that the chart includes new rows and that the summary totals update as intended.
  • Choose a chart based on the question. A combined pie answers “What share of the overall total belongs to each category?” Separate pies or a clustered bar chart answer “How do the groups differ?” For side-by-side comparison, bars are usually easier to read because people can compare lengths more accurately than slice angles.
  • Use consistent colors and labels. If you show separate charts for multiple groups, assign the same color to the same category in each chart. Include units and the reporting period in the title or a nearby note. These small choices make the charts easier to interpret without requiring readers to inspect the source table.

Troubleshooting

The chart is blank or contains the wrong categories: Click the chart and choose Chart Design > Select Data. Verify that the chart data range contains the intended category labels and the combined values. Check for blank cells, text values, or a header row accidentally treated as a slice. If you made a non-adjacent selection, rebuild the selection using Ctrl on Windows or Command on Mac, or copy the labels and totals into adjacent columns first.

Excel displays separate pies or an unexpected chart: The selected range may include more than one series, or Excel may have guessed the data orientation incorrectly. A standard pie needs one series of values and a corresponding list of category labels. In Select Data, remove unintended series or revise the range. If the goal is to show two series separately, use two charts or choose a chart type that supports group comparisons.

Some values do not appear or the pie looks incomplete: Check that values are numeric, nonnegative, and included in the source range. Text such as “$25” may be stored as text rather than a number; correct the cell format or re-enter the value as a number and apply currency formatting. Also confirm that the chart is not using a filtered range or missing the last row.

The percentages do not match your calculations: Excel calculates each percentage from the values plotted in that pie, not from a separate grand total unless that total is included in the plotted data. Confirm the selected values and ensure you have not included the original group columns alongside the combined totals. For the example, the chart should total 140, so 65 divided by 140 is about 46.4%.

Labels overlap or the small slices are hard to see: Reduce the number of categories, move labels outside the pie, or show only category names or percentages. You can also use a Pie of Pie chart for small categories. If readers still cannot compare values comfortably, switch to a bar chart rather than shrinking the text or adding more labels.

Frequently Asked Questions

Can I combine two existing pie charts without the original data?
Not reliably by merging the chart objects. You need the values behind both charts to calculate accurate combined slices. If those values are unavailable, retrieve the source workbook or ask for the data; estimating from slice angles can introduce significant errors.

Can one Excel pie chart show two data series?
A standard pie chart is designed for one series. To show two groups, use separate pies with matching categories and colors, or use a clustered bar or column chart. A Pie of Pie chart is another option for splitting smaller categories from one series, not for comparing two groups.

How do I combine categories with the same name?
Standardize the labels first, then add the values belonging to each category into one total. For example, “Apples,” “Apple,” and “ apples ” may need to be corrected to the same label before summarizing. A PivotTable can group identical category names and sum their values.

Can I combine pies from different worksheets?
Yes. Copy or reference the category totals from each worksheet into one summary table, with one row per category and one column per source. Add the values for each matching category, then chart the category names and combined totals. Keep the source sheet names or periods in the summary if you need to trace where the figures came from.

How can I compare two pie charts fairly?
Use the same categories, category colors, and time period in both charts, and make the group totals clear. Remember that each pie’s percentages are calculated against its own total, so equal-sized slices do not necessarily represent equal numbers. If absolute values matter, add data labels with values or use a bar chart.

Related

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.