GrapeCity.Documents.Excel.Drawing.ISeries.Values

Values Property

Values

Gets or sets all values in the series.

The values can come from a worksheet range or from an array of constant values, but not from a combination of both.

Declaration

double?[] Values { get; set; }

Property Values As Double?()

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 12},
    {"Feb", 18},
    {"Mar", 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
ISeries series = chart.SeriesCollection[0];
double?[] values = series.Values;