In this tutorial we will be creating Trend Lines. We will then use the Trend Line to Forecast the data.

  1. 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.
    1. Bar With Trendline Bar With Trendlline And Forecast
      Bar Graph With Trend line Bar Graph With Trend line And Forecast
      Line And Forecast Line With Trend And Forecast
      Line Graph And Forecast Line Graph With Trend And Forecast
      Bubble With Forecast Bubble With Trendline And Forecast
      Bubble With Forecast Bubble With Trend line And Forecast
  2. We will now create a chart with a Trend Line.
  3. Launch Aioob Flash Chart Maker
  4. Select Create a New Chart
    1. Create a New Chart
  5. From the Create a New Chart select the Column button.
    1. Create a New Chart
  6. You will now see your chart in the workspace layout:
    1. Workspace Layout
  7. The workspace layout is divided into two sections (a properties section and a preview section):
    1. workspace layout
  8. 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.
  9. From the properties section select the Trend Lines and Forecast tab.
  10. In the Trend Lines and Forecast select Series Blue from the Series drop-down box.
    1. Trend Lines and Forecast
  11. Now press the Add button to add a trend line to Series Blue.
  12. You will now see that a trend line called Trend1 for 'Series Blue' has been added to Series Blue.
    1. Trend1 for 'Series Blue' is a Linear function (by default) based on the data values of Series Blue.
  13. We will now edit this trend line. Select Trend1 for 'Series Blue' and press the Edit button.
  14. The Edit box will pop up. We will now use a different function type for our trend line.
  15. From the Edit box, select the property TrendType and then press the Edit button.
  16. You will now have the following 5 functions and the moving averages, to choose from:
    1. Logarithmic function
    2. Exponential function
    3. Power function
    4. Moving Averages
    5. Linear function
    6. Polynomial function
  17. Select the Polynomial function and press Apply.
    1. Select the Polynomial function
  18. Trend1 for 'Series Blue' has now been changed from using the Linear function into the Polynomial function.
  19. We will now use this function to forecast our data.
  20. From the Edit box, scroll down to and select the property IsForecast and then press the Edit button.
  21. Press the IsForecast check box by selecting it (a tick will appear). Now press the Apply button.
    1. Selecting IsForecast
  22. Trend1 for 'Series Blue' will now be used to forecast the data for Series Blue.
  23. Close the Edit box, by pressing the Close button.
  24. 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.
    1. Forward Forecast
  25. You will see that the trend line Trend1 for 'Series Blue' has forecasted the data for Series Blue.
  26. The following properties for a trend line can be changed in a similar way:
    1. TrendFunctionName -The name of the trend line function.
    2. 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.
    3. IsForecast - You can use this attribute to decide, whether or not, the trend line function should be used to forecast your data.
    4. 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.
    5. HideTrendLine - Show or hide a trend line function.
    6. 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)..
    7. LineAlpha - The alpha blending of the trend line.
    8. LineColor - The color of the trend line.
    9. TrendCoordinateAlpha - The alpha blending of the coordinate points in the trend line.
    10. TrendCoordinateBackgroundColor - The background color of the coordinate points in the trend line.
    11. TrendCoordinateBorderColor - The outer border color of the coordinate points in the trend line.
    12. TrendCoordinateShape - The shape of the coordinate points in the trend line.
    13. TrendCoordinateSize - The size of the coordinate points in the trend line.
    14. TrendLineThickness - The thickness of the trend line.