ShowValue Property (DataLabelSettings)

Gets or sets a value that indicates whether to show the value.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ShowValue As System.Boolean

'Usage
 
Dim instance As DataLabelSettings
Dim value As System.Boolean
 
instance.ShowValue = value
 
value = instance.ShowValue

public System.bool ShowValue {get; set;}

Property Value

true to show the value; otherwise, false.

Example

This example sets the ShowPointValue 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.Purple);
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.Normal;
dataLabel.Foreground = new SolidColorBrush(Colors.DarkGray);
chart.DataSeries.Add(ds);
gcSpreadSheet1.ActiveSheet.Charts.Add(chart);

VB.NET

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.Purple)
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.Normal
dataLabel.Foreground = New SolidColorBrush(Colors.DarkGray)
chart.DataSeries.Add(ds)
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

DataLabelSettings Class
DataLabelSettings Members