GrapeCity.Documents.Excel.Drawing.IDataLabels.NumberFormatLinked

NumberFormatLinked Property

NumberFormatLinked

Gets or sets whether the data label number format is linked to the source cells.

When this property is true, changes to the number format in the source cells are reflected in the data labels.

Declaration

bool NumberFormatLinked { get; set; }

Property NumberFormatLinked As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 1200},
    {"Feb", 1500},
    {"Mar", 1100}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
ISeries series = chart.SeriesCollection[0];
series.HasDataLabels = true;
bool linked = series.DataLabels.NumberFormatLinked;