GrapeCity.Documents.Excel.Drawing.ITickLabels.NumberFormat

NumberFormat Property

NumberFormat

Gets or sets the number format code for the tick labels.

The returned format code controls how numeric values are displayed on the chart axis, chart axis, such as currency, percentage, or decimal formatting.

Declaration

string NumberFormat { get; set; }

Property NumberFormat As String

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 1200},
    {"Feb", 1500},
    {"Mar", 1100}
};
worksheet.Range["B2:B4"].NumberFormat = "$#,##0";
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
IAxis axis = chart.Axes.Item(AxisType.Value, AxisGroup.Primary);
string numberFormat = axis.TickLabels.NumberFormat;