DateAxis Class

Namespace:: GemBox.Spreadsheet.Charts

Assembly:: GemBox.Spreadsheet.dll

Represents an axis used for categories which are dates / times.

C#
VB.NET

public sealed class DateAxis : ChartAxis

Public NotInheritable Class DateAxis
    Inherits ChartAxis

Inheritance:: System.Object
ChartAxis
DateAxis

Properties

AxisType

Gets the axis type for DateAxis which is Date.

C#
VB.NET

public override AxisType AxisType { get; }

Public Overrides ReadOnly Property AxisType As AxisType

Property Value

AxisType

The Date value.

Overrides

ChartAxis.AxisType

BaseUnit

Gets or sets the smallest time unit that is represented on the date axis or null if value should be automatically calculated based on chart's data.

C#
VB.NET

public TimeUnit? BaseUnit { get; set; }

Public Property BaseUnit As TimeUnit?

Property Value

System.Nullable<TimeUnit>

The smallest time unit that is represented on the date axis or null if value should be automatically calculated based on chart's data.

MajorTimeUnit

Gets or sets the time unit for MajorUnit.

C#
VB.NET

public TimeUnit MajorTimeUnit { get; set; }

Public Property MajorTimeUnit As TimeUnit

Property Value

TimeUnit

The time unit for major tick marks.

MajorUnit

Gets or sets the distance between major ticks or null if value should be automatically calculated based on chart's data.

C#
VB.NET

public double? MajorUnit { get; set; }

Public Property MajorUnit As Double?

Property Value

System.Nullable<System.Double>

The distance between major ticks or null if value should be automatically calculated based on chart's data.

Exceptions

System.ArgumentOutOfRangeException

Value is not positive number.

Maximum

Gets or sets the maximum value of the axis or null if value should be automatically calculated based on chart's data.

C#
VB.NET

public DateTime? Maximum { get; set; }

Public Property Maximum As Date?

Property Value

System.Nullable<System.DateTime>

The maximum value of the axis or null if value should be automatically calculated based on chart's data.

Minimum

Gets or sets the minimum value of the axis or null if value should be automatically calculated based on chart's data.

C#
VB.NET

public DateTime? Minimum { get; set; }

Public Property Minimum As Date?

Property Value

System.Nullable<System.DateTime>

The minimum value of the axis or null if value should be automatically calculated based on chart's data.

MinorTimeUnit

Gets or sets the time unit for MinorUnit.

C#
VB.NET

public TimeUnit MinorTimeUnit { get; set; }

Public Property MinorTimeUnit As TimeUnit

Property Value

TimeUnit

The time unit for minor tick marks.

MinorUnit

Gets or sets the distance between minor ticks or null if value should be automatically calculated based on chart's data.

C#
VB.NET

public double? MinorUnit { get; set; }

Public Property MinorUnit As Double?

Property Value

System.Nullable<System.Double>

The distance between minor ticks or null if value should be automatically calculated based on chart's data.

Exceptions

System.ArgumentOutOfRangeException

Value is not positive number.

Inherited Properties

CrossType	Gets or sets the axis cross configuration. (Inherited from ChartAxis)
CrossesAt	Gets or sets the specific value or category on which the opposite axis should be positioned. To be used with CrossType set to Specific. (Inherited from ChartAxis)
Fill	Gets or sets the fill formatting options. (Inherited from ChartAxis)
IsVisible	Gets or sets a value indicating whether axis is visible. (Inherited from ChartAxis)
LabelsPosition	Gets or sets the axis labels position. (Inherited from ChartAxis)
MajorGridlines	Gets the major gridlines. (Inherited from ChartAxis)
MajorTickMarkType	Gets or sets the major tick marks position. (Inherited from ChartAxis)
MinorGridlines	Gets the minor gridlines. (Inherited from ChartAxis)
MinorTickMarkType	Gets or sets the minor tick marks position. (Inherited from ChartAxis)
NumberFormat	Gets or sets the number format used for formatting axis value labels. If NumberFormatLinkedToSource is true, then number format from chart's source data (cells) will be used to format axis value labels as explained in remarks. Setting this property, sets NumberFormatLinkedToSource to false. (Inherited from ChartAxis)
NumberFormatLinkedToSource	Gets or sets a value indicating whether number format from chart's source data (cells) will be used to format axis value labels. (Inherited from ChartAxis)
Outline	Gets or sets the outline formatting options. (Inherited from ChartAxis)
ReverseOrder	Gets or sets a value indicating whether values on the axis shall be reversed so they go from maximum to minimum. This value is currently not supported when exporting a chart to PDF, XPS, or image formats. This value is always exported as false. (Inherited from ChartAxis)
TextBoxFormat	Gets or sets the text box formatting. (Inherited from ChartAxis)
TextFormat	Gets or sets the text formatting options. (Inherited from ChartAxis)
Title	Gets the axis title. (Inherited from ChartAxis)

Inherited Methods

ChangeAxisType(AxisType)	Changes the type of the axis. (Inherited from ChartAxis)
ChangeAxisType<TChartAxis>()	Changes the type of the axis. (Inherited from ChartAxis)
Delete()	Deletes axis. (Inherited from ChartAxis)
ToString()	Returns a System.String that represents this ChartAxis instance. (Inherited from ChartAxis)