GrapeCity.Documents.Excel.Drawing.ITickLabels

ITickLabels Interface

Represents the tick-mark labels associated with a chart axis.

Use this interface to format and position axis labels, including their font, number format, text direction, text orientation, and label offset. An ITickLabels object is returned by TickLabels.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface ITickLabels

Public Interface ITickLabels

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 1200}, {"Feb", 1500}, {"Mar", 1800}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 230);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
IAxis categoryAxis = shape.Chart.Axes.Item(AxisType.Category);
ITickLabels tickLabels = categoryAxis.TickLabels;
tickLabels.Direction = TextDirection.Vertical;

Properties

Name	Description
Direction	Gets or sets the text direction for the tick-mark labels. Use this property to determine how the text in chart axis tick labels is oriented, such as horizontal or vertical layout.
Font	Gets the IFontFormat object for the tick labels. Use the returned font format to read or modify font settings for the text displayed in the chart axis tick labels.
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.
NumberFormatLinked	Gets or sets whether the tick label number format is linked to the source cells. If this property is `true`, changes to the number format in the source cells are reflected in the axis tick labels.
Offset	Gets or sets the distance between label levels and between the first label level and the axis line. Use this property to read the current spacing applied to tick-mark labels on a chart axis.
Orientation	Gets or sets the text orientation of the tick-mark labels. The returned value represents the rotation angle of the tick-mark label text, in degrees.
Parent	Gets the parent IAxis that contains these tick labels. Use this property to access the axis associated with the current tick labels when you need to continue configuring the axis after working with its labels.