GrapeCity.Documents.Excel.Drawing.IDataLabels.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 labels display multiple elements, such as the series name and value.

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"]);
IDataLabels dataLabels = chart.SeriesCollection[0].DataLabels;
dataLabels.ShowSeriesName = true;
dataLabels.ShowValue = true;
dataLabels.Separator = " - ";
string separator = dataLabels.Separator;