The requirement is to get the chart data range programmatically via SpreadSheetGear. It seems there is no API to return chart data range directly in SpreadSheetGear, the only way is to calculate the range. What I am doing now is to go through all the Series in the chart, get the starting/ending row/column and compose them to range object, But this doesn't work for most senerios. Is there any way to solve this problem without setting some some special function or naming range?