Microsoft Office Tutorials and References
In Depth Information
Formatting a trendline
Trendline name: If you choose Custom, you can provide a different
caption for the trendline. This is the text that appears in the legend. If you do
not specify a custom name, the legend text consists of the trendline type,
followed by the series name in parentheses.
Forecast: These options enable you to extend the trendline either forward,
backward, or in both directions. You specify the number of periods to
forecast.
Set intercept: Enables you to specify the point on the value axis where
the trendline crosses the axis.
Display equation on chart: If checked, the regression equation for the
trendline will be displayed on the chart.
Display R-squared value on chart: If checked, the R-squared value for
the trendline will be displayed on the chart.
A single series can have more than one trendline associated with it. For
example, you may want to add two different trendlines to determine which
type better fits the data.
Formatting a trendline
When Excel inserts a trendline, it may look like a new data series, but it’s not. It’s a
new chart element with a name, such as Series 1 Trendline 1. And, of course, it does
not have a corresponding SERIES formula. Double-click a trendline to display the
Format Trendline dialog box, which enables you to change its formatting or its
options (the same options that were available when you added the trendline).
Formatting a trendline “data label”
If you choose either of the options that display a trendline equation or the
R-squared value, the trendline will be accompanied by a text item that displays the
requested information (see Figure 5-7). Excel refers to this as a data label —
although, strictly speaking, it’s not.
When the data changes, the data label is updated automatically to display the
recalculated equation. To move the data label, just drag it. To change the
formatting, select it and choose Format
Selected Data Labels.
Search JabSto ::




Custom Search