Date Axis
Date/Time Axis
Price Axis
Numerical Axis
Volume Axis
X Axis
Date/Time Axis or Numerical Axis
Y Axis
User-Named Axis
The Date/Time Axis object is a linear axis that maps temporal data to one of the dimensions of a chart and formats labels as dates and times. Valid properties for the Date/Time Axis object are described in the following table.
LowerLimit
DateTime
Lower bound of the axis if AutoScaleLower is False. The property is ignored if AutoScaleLower is True.
False
True
UpperLimit
Upper bound of the axis if AutoScaleUpper is False. The property is ignored if AutoScaleUpper is True.
AutoScaleLower
Boolean
Automatically determines a suitable lower axis limit based on the data.
AutoScaleUpper
Automatically determines a suitable upper limit based on the data.
ReverseScale
Reverses the direction of the axis, placing the lower bound at the end of the axis rather than at the beginning.
Visible
Shows or hides the axis, its labels, and its tick marks. This option does not affect the mapping of data.
MajorFontName
FontName
Font used for major labels.
MajorFontSize
Numeric
Size of the font used for major labels.
MajorFontBold
Displays major labels in bold.
MajorFontItalic
Displays major labels in italics.
MajorFontColor
Color
Sets the color of major labels.
MinorFontName
Font used for minor labels.
MinorFontSize
Size of the font used for minor labels.
MinorFontBold
Displays minor labels in bold.
MinorFontItalic
Displays minor labels in italics.
MinorFontColor
Sets the color of minor labels.
LabelSpacing
Distance between the label and the axis.
MajorTickLen
Length of tick marks at major intervals.
MinorTickLen
Length of tick marks at minor intervals.
TicksInside
Displays tick marks on the inside of the axis (toward the center of the plot area).
TicksOutside
Displays tick marks on the outside of the axis (away from the center of the plot area).
LengthPct
Percentage
Relative length of the axis compared to other axes with the same alignment. The sum of the LengthPct properties for all axes aligned in the same direction is normalized to 100%.
The Numerical Axis object maps value-based data to one of the dimensions of a chart. Its labels are dynamic during zoom operations so that suitable increments are displayed at all times. Valid properties for the Numerical Axis object are described in the following table
Scale
Enum
Type of scale:
0
1
NumberFormat
String
Determines the display format of numbers along the axis. Defaults to General, which displays the number in its most compact form. See "Formatting Values" for more information.
General
Font used for labels.
FontSize
Size of the font used for labels.
FontBold
Displays labels in bold.
FontItalic
Displays labels in italics.
FontColor
Sets the color of labels.