Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / DataLabelSettings Class / DataLabelSettings Constructor
Example


In This Topic
    DataLabelSettings Constructor
    In This Topic
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New DataLabelSettings()
    public DataLabelSettings()
    Example
    This example creates a chart.
    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