chart_series_set_values

@brief Set a series "values" range using row and column values.

@param series A series object created via chart_add_series(). @param sheetname The name of the worksheet that contains the data range. @param first_row The first row of the range. (All zero indexed.) @param first_col The first column of the range. @param last_row The last row of the range. @param last_col The last col of the range.

The categories and values of a chart data series are generally set using the chart_add_series() function and Excel range formulas like "=Sheet1!$A$2:$A$7".

The %chart_series_set_values() function is an alternative method that is easier to generate programmatically. See the documentation for chart_series_set_categories() above.

Meta