How to Combine Pie Charts Into a Single Figure in Excel

By Ryan Menezes

Spreadsheet pie charts must match each other in size.
i Jason Reed/Photodisc/Getty Images

If your Excel spreadsheet includes multiple pie charts, you may need to edit their designs simultaneously because editing one but not the other distorts your view of them. For example, if each charts breaks down your profits from different products in one years, readers will look from one chart to the other for comparison. If one chart is larger, they will be unable to properly compare one chart's wedge to its corresponding wedge in the second chart. To resize the charts together, combine them into a single figure.

Click one pie chart to select it.

Hold down the "Shift" key and click the other pie chart to select it as well.

Click "Format" in the Excel ribbon.

Click "Group" in the ribbon's Arrange tab to open a drop-down menu.

Click "Group" in the menu to combine the charts as a single figure.


Information in this article applies to Excel 2010. It may vary slightly or significantly with other versions.