GrapeCity.Documents.Excel.Drawing.IDataLabels.Format

Format Property

Format

Gets the IChartFormat object for the data labels.

Use the returned object to access fill, line, and other formatting settings that apply to the data labels of the series.

Declaration

IChartFormat Format { get; }

ReadOnly Property Format As IChartFormat

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 10},
    {"B", 20}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B3"], RowCol.Columns);
ISeries series = shape.Chart.SeriesCollection[0];
series.HasDataLabels = true;
IChartFormat format = series.DataLabels.Format;
format.Fill.Color.RGB = Color.Red;