Click or drag to resize

IChartFormat ShowNegativeBubbles Property

True to show negative bubbles.
Examples
The following code illustrates how to load negative values to ExcelChartType.Bubble3D chart value axis and set ShowNegativeBubbles to "true":
<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:D2"];</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 negative bubble visibility</para><para>format.ShowNegativeBubbles = true;</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
bool ShowNegativeBubbles { get; set; }

Property Value

Type: Boolean
See Also