Click or drag to resize

IChartFormat SizeRepresents Property

Returns or sets what the bubble size represents on a bubble chart.
Examples
The following code illustrates how to set BubbleSizeType.Width to SizeRepresents property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add(ExcelChartType.Bubble3D);</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>chart.Series[0].Bubbles = worksheet.Range["A2:C3"];</para><para>//Set chart format</para><para>IChartFormat format = chart.Series[0].Format.Options;</para><para>//Set bubble scale and size represents</para><para>format.BubbleScale = 50;</para><para>format.SizeRepresents = BubbleSizeType.Width;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
BubbleSizeType SizeRepresents { get; set; }

Property Value

Type: BubbleSizeType
See Also