Part III: Creating Charts and Other Visualizations
To specify the type of trendline, click the arrow to the right of the Trendline item. The
type of trendline that you choose depends on your data. Linear trends (see Figure 21.26)
are most commonly used and the easiest to apply.
FIGURE 21.26
Applying a trend line
For more control over a trendline, select More Options from the trendline choices shown in
Figure 21.26.
This will activate the Format Trendline task pane illustrated in Figure 21.27. Here you can
apply more advanced trendlines such as logarithmic, exponential, and moving average
trendlines.
Creating combination charts
A combination chart is a single chart that consists of series that use different chart types. A
combination chart may also include a second value axis. For example, you may have a chart
that shows both columns and lines, with two value axes. The value axis for the columns is
on the left, and the value axis for the line is on the right. A combination chart requires at
least two data series.
Figure 21.28 shows a column chart with two data series. The values for the Precipitation
series are so low that they’re barely visible on the Value Axis scale. This is a good candidate
for a combination chart.
