Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadDataSeries Class / GetDataLabel Method
Index of the point.
Example


In This Topic
    GetDataLabel Method
    In This Topic
    Gets the data label.
    Syntax
    'Declaration
     
    Public Function GetDataLabel( _
       ByVal pointIndex As Integer _
    ) As DataLabel
    'Usage
     
    Dim instance As SpreadDataSeries
    Dim pointIndex As Integer
    Dim value As DataLabel
     
    value = instance.GetDataLabel(pointIndex)
    public DataLabel GetDataLabel( 
       int pointIndex
    )

    Parameters

    pointIndex
    Index of the point.
    Example
    This example uses the GetDataLabel method.
    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