Excel 2010 Bible

Part III: Creating Charts and Graphics

464

FIGURE 19.25

An XY chart with a linear trendline.

FIGURE 19.26

The dashed line displays a seven-interval moving average.

Modifying 3-D charts

3-D charts have a few additional elements that you can customize. For example, most 3-D charts

have a floor and walls, and true 3-D charts also have an additional axis. You can select these chart

elements and format them to your liking using the Format dialog box.

One area in which Excel 3-D charts differ from 2-D charts is in the perspective — or viewpoint —

from which you see the chart. In some cases, the data may be viewed better if you change the order

of the series.