Click or drag to resize

IChartAxis NumberFormat Property

Gets or sets number format string.
Examples
The following code illustrates how to set currency format "$#,##0_);($#,##0)" to NumberFormat to display value in the PrimaryValueAxis as currency:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>worksheet.Range["A1"].Text = "Jan";
 worksheet.Range["B1"].Text = "Feb";
 worksheet.Range["C1"].Text = "Mar";
 worksheet.Range["A2"].Text = "10000";
 worksheet.Range["B2"].Text = "20000";
 worksheet.Range["C2"].Text = "30000";</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart value axis</para><para>IChartAxis chartAxis = chart.PrimaryValueAxis;</para><para>//Set number format</para><para>chartAxis.NumberFormat = @"$#,##0_);($#,##0)";</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
Copy 
string NumberFormat { get; set; }

Property Value

Type: String
See Also