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.

Image

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 ...

Get Office 2013 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.