Excel 2010 Bible

Part III: Creating Charts and Graphics

468

Note
In some cases, you can’t combine chart types. For example, you can’t create a combination chart that involves
a bubble chart or a 3-D chart. If you choose an incompatible chart type for the series, Excel lets you know. n

Figure 19.31 demonstrates just how far you can go with a combination chart. This chart combines

five different chart types: Pie, Area, Column, Line, and XY. I can’t think of any situation that would

warrant such a chart, but it’s an interesting demo.

FIGURE 19.31

A five-way combination chart.

Displaying a data table

In some cases, you may want to display a data table, which displays the chart’s data in tabular

form, directly in the chart.

To add a data table to a chart, choose Chart Tools ➪ Layout ➪ Labels ➪ Data Table. This control

is a drop-down list with a few options to choose from. For more options, use the Format Data

Table dialog box. Figure 19.32 shows a combination chart that includes a data table.