How to Combine Pie Charts Into a Single Figure in Excel. Pie charts are unique among the types of graphs Excel can make because they only work with limited sets of data.

Pie charts are used to show percentages of the whole, and Line charts excel with data trends. The remaining chart designs include Area, Stock, Surface, Combo, Pareto, Histogram, and Sunburst.

When you create a pie chart in Microsoft Excel, three new tabs appear that offer several formatting options. One option is to overlay built-in shapes, such as block arrows that are useful as pointers.