GrapeCity.Documents.Excel.Drawing.IDataLabel.Separator

Separator Property

Separator

Gets or sets the separator used between parts of the data label text on a chart.

This separator is used when the data label displays multiple elements, such as the series name, category name, value, or percentage.

Declaration

string Separator { get; set; }

Property Separator As String

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"]);
IDataLabel dataLabel = chart.SeriesCollection[0].Points[0].DataLabel;
dataLabel.Separator = " - ";
string separator = dataLabel.Separator;