Office 2013 In Depth

Creating a Combination Chart

Before we end our discussion of Excel charts, we should look at how you create a combination chart. A combination chart combines two or more chart types in a single chart. Excel provides premade combination charts such as pie of pie and bar of pie charts. A pie of pie chart is shown in Figure 14.22.

Figure 14.22. Pie of Pie chart.

A pie of pie chart (or a bar of pie chart) enables you to separate out certain data points into the secondary chart, meaning the second pie. This can be extremely useful when you have a situation where a few large data points dominate the pie chart and you would like to make smaller slices ...