Spread WPF Documentation
ShowCategoryName Property
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > DataLabelSettings Class : ShowCategoryName Property
Gets or sets a value that indicates whether to show the category name.
Syntax
'Declaration
 
Public Property ShowCategoryName As System.Boolean
'Usage
 
Dim instance As DataLabelSettings
Dim value As System.Boolean
 
instance.ShowCategoryName = value
 
value = instance.ShowCategoryName
public System.bool ShowCategoryName {get; set;}

Property Value

true to show the category name; otherwise, false.
Example
This example sets the ShowCategoryName property.
GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble, 0, 0, 200, 200);

GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries ds = new GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries();
ds.Values.Add(4);
ds.Values.Add(7);
ds.Values.Add(6);
ds.Values.Add(10);
ds.Values.Add(4);

//DataSeries level
ds.DataLabelSettings = new GrapeCity.Windows.SpreadSheet.Data.DataLabelSettings();
ds.DataLabelSettings.ShowValue = true;
ds.DataLabelSettings.ShowSeriesName = true;
ds.DataLabelSettings.ShowPercent = true;
ds.DataLabelSettings.ShowCategoryName = true;
ds.DataLabelSettings.ShowBubbleSize = true;

ds.DataLabelStyle.Fill = new SolidColorBrush(Colors.Green);
ds.DataLabelStyle.Stroke = new SolidColorBrush(Colors.Aqua);
ds.DataLabelStyle.StrokeDashType = GrapeCity.Windows.SpreadSheet.Data.StrokeDashType.Dash;
ds.DataLabelStyle.StrokeThickness = 2;
ds.DataLabelStyle.FontSize = 12;
ds.DataLabelStyle.FontFamily = new FontFamily("Arial Narrow");
ds.DataLabelStyle.FontStyle = FontStyles.Italic;
ds.DataLabelStyle.FontWeight = FontWeights.Bold;
ds.DataLabelStyle.FontStretch = FontStretches.Normal;
ds.DataLabelStyle.Foreground = new SolidColorBrush(Colors.Blue);

//DataLabel level
GrapeCity.Windows.SpreadSheet.Data.DataLabel dataLabel = ds.GetDataLabel(0);
dataLabel.DataLabelSettings = new GrapeCity.Windows.SpreadSheet.Data.DataLabelSettings();
dataLabel.DataLabelSettings.ShowValue = false;
dataLabel.DataLabelSettings.ShowSeriesName = true;
dataLabel.DataLabelSettings.ShowPercent = true;
dataLabel.DataLabelSettings.ShowCategoryName = true;
dataLabel.DataLabelSettings.ShowBubbleSize = true;

dataLabel.Fill = new SolidColorBrush(Colors.Transparent);
dataLabel.Stroke = new SolidColorBrush(Colors.Red);
dataLabel.StrokeDashType = GrapeCity.Windows.SpreadSheet.Data.StrokeDashType.Dash;
dataLabel.StrokeThickness = 2;
dataLabel.FontSize = 10;
dataLabel.FontFamily = new FontFamily("Arial Narrow");
dataLabel.FontStyle = FontStyles.Italic;
dataLabel.FontWeight = FontWeights.Bold;
dataLabel.FontStretch = FontStretches.Medium;
dataLabel.Foreground = new SolidColorBrush(Colors.Azure);
chart.DataSeries.Add(ds);
gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble, 0, 0, 200, 200)

Dim ds As New GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries()
ds.Values.Add(4)
ds.Values.Add(7)
ds.Values.Add(6)
ds.Values.Add(10)
ds.Values.Add(4)

'DataSeries level
ds.DataLabelSettings = New GrapeCity.Windows.SpreadSheet.Data.DataLabelSettings()
ds.DataLabelSettings.ShowValue = True
ds.DataLabelSettings.ShowSeriesName = True
ds.DataLabelSettings.ShowPercent = True
ds.DataLabelSettings.ShowCategoryName = True
ds.DataLabelSettings.ShowBubbleSize = True

ds.DataLabelStyle.Fill = New SolidColorBrush(Colors.Green)
ds.DataLabelStyle.Stroke = New SolidColorBrush(Colors.Aqua)
ds.DataLabelStyle.StrokeDashType = GrapeCity.Windows.SpreadSheet.Data.StrokeDashType.Dash
ds.DataLabelStyle.StrokeThickness = 2
ds.DataLabelStyle.FontSize = 12
ds.DataLabelStyle.FontFamily = New FontFamily("Arial Narrow")
ds.DataLabelStyle.FontStyle = FontStyles.Italic
ds.DataLabelStyle.FontWeight = FontWeights.Bold
ds.DataLabelStyle.FontStretch = FontStretches.Normal
ds.DataLabelStyle.Foreground = New SolidColorBrush(Colors.Blue)

'DataLabel level
Dim dataLabel = ds.GetDataLabel(0)
dataLabel.DataLabelSettings = New GrapeCity.Windows.SpreadSheet.Data.DataLabelSettings()
dataLabel.DataLabelSettings.ShowValue = False
dataLabel.DataLabelSettings.ShowSeriesName = True
dataLabel.DataLabelSettings.ShowPercent = True
dataLabel.DataLabelSettings.ShowCategoryName = True
dataLabel.DataLabelSettings.ShowBubbleSize = True

dataLabel.Fill = New SolidColorBrush(Colors.Transparent)
dataLabel.Stroke = New SolidColorBrush(Colors.Red)
dataLabel.StrokeDashType = GrapeCity.Windows.SpreadSheet.Data.StrokeDashType.Dash
dataLabel.StrokeThickness = 2
dataLabel.FontSize = 10
dataLabel.FontFamily = New FontFamily("Arial Narrow")
dataLabel.FontStyle = FontStyles.Italic
dataLabel.FontWeight = FontWeights.Bold
dataLabel.FontStretch = FontStretches.Medium
dataLabel.Foreground = New SolidColorBrush(Colors.Azure)
chart.DataSeries.Add(ds)
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
See Also

Reference

DataLabelSettings Class
DataLabelSettings Members