'Declaration Public Function New()
'Usage Dim instance As New DataLabelSettings()
public DataLabelSettings()
'Declaration Public Function New()
'Usage Dim instance As New DataLabelSettings()
public DataLabelSettings()
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)