IEaxChart.Range

Syntax

Description

The Range property determines the range of selected table area based on which the chart is plotted.

Comments

If only one cell is selected in the table. the chart is plotted by all table data. As a value of the Range property, the range is specified, in which:

Left - Left column index.
Top - Top row index.
Right - Right column index.
Bottom - Bottom row index.

Example

Sub UserProc;
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    Expr: IEaxAnalyzer;
    EChart: IEaxChart;
    Rect1: IGxRect;
Begin
    MB := MetabaseClass.Active;
    MObj := MB.ItemById("EXPRESS_REPORT").Edit;
    Expr := MObj As IEaxAnalyzer;
    EChart := Expr.Chart;
    Expr.UseGridSelection := True;
    Rect1 := New GxRect.Create(1, 40, 2, 60);
    EChart.Range := Rect1;
    MObj.Save;
End Sub UserProc;

After executing the example, the B40:C60 cell range becomes selected and a chart is plotted based on this cell range. Express report identifier - EXPRESS_REPORT.