@TRENDLINE (Draw a Trend Line)

This macro draws a trend line across a specified series.

SYNTAX:

@TRENDLINE nSeries nValue

PARAMETERS:

nSeries; 0...511 Series (0=Series 1) to apply the trend line.

nValue; Bitwise flags (0...127) to activate one or more of the following trend lines:
1 = MEAN
2 = Standard Deviation
4 = Linear Regression
8 = Natural Log Regression
16 = Polynomial Regression
32 = Exponential Regression
64 = Log Regression

EXAMPLE: @TRENDLINE.RPT

This example draws both Linear AND Polynomial regression lines on the first series:

@TRENDLINE 0 20

PERSISTENT:

YES

REQUIREMENTS:

Crystal Reports 9 or Higher

ALSO SEE:

@MOVA; to draw a moving average line

@TRENDLINE_ALLDATA to draw a linear regression line through all data points in a chart

Next Macro Previous Macro Return to Alpha List

Next Macro in this Group Previous Macro in this Group Return to Group List