How to Combine Pie Charts Into a Single Figure in Excel
By Ryan Menezes
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.
Ryan Menezes is a professional writer and blogger. He has a Bachelor of Science in journalism from Boston University and has written for the American Civil Liberties Union, the marketing firm InSegment and the project management service Assembla. He is also a member of Mensa and the American Parliamentary Debate Association.