In this tutorial we will be creating Trend Lines. We will then use the Trend
Line to Forecast the data.
Check out the following examples of how the end users can edit the trend
lines and forecast the data in your chart (in real time), using the
Trend Lines and Forecast Wizard.
From the Create a New Chart select the Column
button.
You will now see your chart in the workspace layout:
The workspace layout is divided into two sections (a properties section
and a preview section):
If you look at your chart in the preview section,
you will see that we have two series in our Bar Graph (Series Red
and Series Blue). We will now add a trend line to the
Series Blue Bar Graph.
In the Trend Lines and Forecast select Series Blue
from the Series drop-down box.
Now press the Add button to add a trend line to
Series Blue.
You will now see that a trend line called Trend1 for 'Series Blue'
has been added to Series Blue.
Trend1 for 'Series Blue' is a Linear function (by default)
based on the data values of Series Blue.
We will now edit this trend line. Select Trend1 for 'Series Blue'
and press the Edit button.
The Edit box will pop up. We will now use a different function
type for our trend line.
From the Edit box, select the property TrendType
and then press the Edit button.
You will now have the following 5 functions and the moving averages, to
choose from:
Logarithmic function
Exponential function
Power function
Moving Averages
Linear function
Polynomial function
Select the Polynomial function and press Apply.
Trend1 for 'Series Blue' has now been changed from using
the Linear function into the Polynomial function.
We will now use this function to forecast our data.
From the Edit box, scroll down to and select the property
IsForecast and then press the Edit button.
Press the IsForecast check box by selecting it (a tick
will appear). Now press the Apply button.
Trend1 for 'Series Blue' will now be used to forecast the
data for Series Blue.
Close the Edit box, by pressing the Close
button.
We will now forecast our data for Series Blue. Go to the
Trend Lines and Forecast tab and select the Forward
Forecast number box. Enter 3 (we will forecast 3 periods), and then
press Apply.
You will see that the trend line Trend1 for 'Series Blue'
has forecasted the data for Series Blue.
The following properties for a trend line can be changed in a similar way:
TrendFunctionName -The name of the trend line function.
OrderOrPeriod - If the TrendType is
a Polynomial function, then this attribute will define the order of the
Polynomial. If the TrendType is Moving Averages, then this
attribute will define the period for it.
IsForecast - You can use this attribute to decide,
whether or not, the trend line function should be used to forecast your
data.
ForecastBubbleSize - You can use this attribute to
decide, whether or not, the trend line function should be used to forecast
the bubble size in a Bubble Chart.
HideTrendLine - Show or hide a trend line function.
ForecastChartAlpha - The alpha blending of the forecasted
data (i.e. the visibility of the forecasted bars, bubbles, points, lines,
candles and sticks, in the chart)..
LineAlpha - The alpha blending of the trend line.
LineColor - The color of the trend line.
TrendCoordinateAlpha - The alpha blending of the coordinate
points in the trend line.
TrendCoordinateBackgroundColor - The background color
of the coordinate points in the trend line.
TrendCoordinateBorderColor - The outer border color
of the coordinate points in the trend line.
TrendCoordinateShape - The shape of the coordinate
points in the trend line.
TrendCoordinateSize - The size of the coordinate points
in the trend line.
TrendLineThickness - The thickness of the trend line.