Chart: IEaxWorkbookChart;
Chart: Prognoz.Platform.Interop.Express.IEaxWorkbookChart;
The Chart property returns chart parameters.
Use the IEaxWorkbook.Statistics property to work with parameters of the statistics panel.
Executing the example requires a form containing:
The button with Button1 identifier.
The LanerBox and LanerResultsBox components.
The UiErAnalayzer component with the UiErAnalayzer1 identifier which is a data source for LanerBox and LanerResultsBox. Workbook of the time series DB must be loaded to UiErAnalyzer1.
Add links to the Collection and Chart system assemblies.
The example is a handler of the OnClick event for the Button1 component. Before button clicking, select calculated series.
Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
Ea: IEaxAnalyzer;
Wb: IEaxWorkbook;
Ch: IEaxWorkbookChart;
Cap: IChartCaption;
Ind: String;
Begin
Ea := UiErAnalyzer1.ErAnalyzer;
Wb := Ea As IEaxWorkbook;
Ch := Wb.Chart;
If Ch.Type = EaxWorkbookChartType.StatMethod Then
If Ch.SerieTypeAvailable(EaxWorkbookChartSerieType.UpperConfidenceLevel) Then
Ch.SerieTypeVisible(EaxWorkbookChartSerieType.UpperConfidenceLevel) := True;
Ind := Ch.SerieTypeIndex(EaxWorkbookChartSerieType.UpperConfidenceLevel).ToString;
Debug.WriteLine("Index of the series corresponding to the upper confidence limit: " + Ind);
End If;
If Ch.SerieTypeAvailable(EaxWorkbookChartSerieType.LowerConfidenceLevel) Then
Ch.SerieTypeVisible(EaxWorkbookChartSerieType.LowerConfidenceLevel) := True;
Ind := Ch.SerieTypeIndex(EaxWorkbookChartSerieType.LowerConfidenceLevel).ToString;
Debug.WriteLine("Index of the series corresponding to the lower confidence limit: " + Ind);
End If;
End If;
Cap := Ch.Chart.Caption;
Cap.Text := Chart;
Cap.Visible := True;
End Sub Button1OnClick;
The header is shown for the chart of the workbook when example is executed. If for selected calculated series upper and lower confidence limits are available, they will be displayed on the chart. Indexes of series corresponding to confident limits will be displayed to the console.
The requirements and result of the Fore.NET Example execution match with those in the Fore Example. Use Fore.NET analogs instead of Fore components.
Imports Prognoz.Platform.Interop.ForeCollections;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Chart;
…
Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
Ea: IEaxAnalyzer;
Wb: IEaxWorkbook;
Ch: IEaxWorkbookChart;
Cap: IChartCaption;
Ind: String;
Begin
Ea := uiErAnalyzerNet1.ErAnalyzer.ErAnalyzer;
Wb := Ea As IEaxWorkbook;
Ch := Wb.Chart;
If Ch.Type = EaxWorkbookChartType.ewctStatMethod Then
If Ch.SerieTypeAvailable[EaxWorkbookChartSerieType.ewcstUpperConfidenceLevel] Then
Ch.SerieTypeVisible[EaxWorkbookChartSerieType.ewcstUpperConfidenceLevel] := True;
Ind := Ch.SerieTypeIndex[EaxWorkbookChartSerieType.ewcstUpperConfidenceLevel].ToString();
System.Diagnostics.Debug.WriteLine("Index of the row corresponding to the upper confidence limit: " + Ind);
End If;
If Ch.SerieTypeAvailable[EaxWorkbookChartSerieType.ewcstLowerConfidenceLevel] Then
Ch.SerieTypeVisible[EaxWorkbookChartSerieType.ewcstLowerConfidenceLevel] := True;
Ind := Ch.SerieTypeIndex[EaxWorkbookChartSerieType.ewcstLowerConfidenceLevel].ToString();
System.Diagnostics.Debug.WriteLine("Index of the row corresponding to the lower confidence limit: " + Ind);
End If;
End If;
Cap := Ch.Chart.Caption;
Cap.Text := Chart;
Cap.Visible := True;
End Sub;
See also: