Excel 2010 Bible

Part III: Creating Charts and Graphics

428

FIGURE 18.25

A stacked area chart.

On the CD
A workbook that contains the charts in this section is available on the companion CD-ROM. The file is named
area charts.xlsx.

Figure 18.26 shows the same data, plotted as a 3-D area chart. As you can see, it’s not an example

of an effective chart. The data for products B and C are obscured. In some cases, the problem can

be resolved by rotating the chart or using transparency. But usually the best way to salvage a chart

like this is to select a new chart type.

FIGURE 18.26

This 3-D area chart is not a good choice.