SetRange
IChartData.SetRange method
Set chart data range. Series and categories will be updated based on new data range. If amount of series in data range greater than count of series in the chart data then additional series with the same type as a last series in the current collection will be added to the end of the collection.
public void SetRange(string formula)
Parameter | Type | Description |
---|
formula | String | The cells data range formula. E.g: “Sheet1!$A$1:$C$4” , “SomeSheetName!A1:B100”, “Sheet1!$A$1:$B$5;Sheet1!$D$1:$D$5”. |
Exceptions
exception | condition |
---|
ArgumentNullException | formula is null. |
ArgumentException | formula has incorrect format. |
See Also