GrapeCity.Documents.Excel.Drawing.IDataLabels.AutoText

AutoText Property

AutoText

Gets or sets whether the data labels automatically generate text based on their current context.

When this property is true, the label text is generated from the chart data and data label settings. When it is false, the labels use explicitly assigned text.

Declaration

bool AutoText { get; set; }

Property AutoText As Boolean

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", 20}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B3"], RowCol.Columns);
ISeries series = chart.SeriesCollection[0];
series.HasDataLabels = true;
IDataLabels dataLabels = series.DataLabels;
bool autoText = dataLabels.AutoText;