接口 IAxis
public interface IAxis
Represents a single axis in a chart.
-
方法概要
修饰符和类型方法说明Returns the actual category axis type.boolean
Gets whether the value axis crosses the category axis (True if the value axis crosses the category axis between categories).Returns the group for the specified axis.Returns anIAxisTitle
object that represents the title of thespecified axis.Gets the base unit for the specified category axis.boolean
Gets whether the units are automatically selected (True if Microsoft Excel chooses appropriate base units for the specified category axis).String[]
Gets all the category names for the specified axis as a text array.Gets the category axis type.Gets the point on the specified axis where the other axis crosses.double
Gets the point on the value axis where the category axis crosses it.Gets the unit label for the value axis.double
Gets whether the displayed units use custom settings (If the DisplayUnit property of the is custom, then the DisplayUnitCustom property returns or sets the value of the displayed units.Returns theIDisplayUnitLabel
object for the specified axis.Returns theIChartFormat
object.boolean
Gets whether the label is displayed on the specified axis (True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis).boolean
Gets whether the axis has major gridlines (True if the axis has major gridlines).boolean
Gets whether the axis has minor gridlines (True if the axis has minor gridlines).boolean
Gets whether the axis or chart has a visible title (True if the axis or chart has a visible title).double
Gets the base of the logarithm when you are using log scales.Returns aIGridlines
object that represents the major gridlines forthe specified axis.Gets the type of major tick mark for the specified axis.double
Gets the major units for the value axis.boolean
Gets whether Excel calculates the major units (True if Microsoft Excel calculates the major units for the value axis).Gets the major unit scale value for the category axis when the CategoryType property is set to TimeScale.double
Gets the maximum value on the value axis.boolean
Gets whether Excel calculates the maximum value (True if Microsoft Excel calculates the maximum value for the value axis).double
Gets the minimum value on the value axis.boolean
Gets whether Excel calculates the miniumum value for the value axis (True if Microsoft Excel calculates the minimum value).Returns theIGridlines
object that represents the minor gridlines forthe specified axis.Gets the type of minor tick mark for the specified axis.double
Gets the minor units on the value axis.boolean
Gets whether Microsoft Excel calculates minor units for the value axis (True if Excel calculates minor units).Gets the minor unit scale value for the category axis when theCategoryType
property is set to TimeScale.Returns the parent object for the specified object.boolean
Gets whether Excel plots data from last to first (True if Microsoft Excel plots data points from last to first).Gets the value axis scale type.Gets the position of tick-mark labels on the specified axis.Returns theITickLabels
object that represents the tick-mark labelsfor the specified axis.int
Gets the number of categories or series between tick-mark labels.boolean
Gets whether the tick label spacing is automatic.int
Gets s the number of categories or series between tick marks.getType()
Returns the Axis type.boolean
Get whether the axis is visible.void
setAxisBetweenCategories
(boolean value) Sets whether the value axis crosses the category axis (True if the value axis crosses the category axis between categories).void
setBaseUnit
(TimeUnit value) Sets the base unit for the specified category axis.void
setBaseUnitIsAuto
(boolean value) Sets whether the units are automatically selected (True if Microsoft Excel chooses appropriate base units for the specified category axis).void
setCategoryNames
(String[] value) Sets all the category names for the specified axis as a text array.void
setCategoryType
(CategoryType value) Sets the category axis type.void
setCrosses
(AxisCrosses value) Sets the point on the specified axis where the other axis crosses.void
setCrossesAt
(double value) Sets the point on the value axis where the category axis crosses it.void
setDisplayUnit
(DisplayUnit value) Sets the unit label for the value axis.void
setDisplayUnitCustom
(double value) Sets whether the displayed units use custom settings (If the DisplayUnit property of the property is custom, then the DisplayUnitCustom property returns or sets the value of the displayed units.void
setHasDisplayUnitLabel
(boolean value) Sets whether the label is displayed on the specified axis (True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis).void
setHasMajorGridlines
(boolean value) Sets whether the axis has major gridlines (True if the axis has major gridlines).void
setHasMinorGridlines
(boolean value) Sets whether the axis has minor gridlines (True if the axis has minor gridlines).void
setHasTitle
(boolean value) Sets whether the axis or chart has a visible title (True if the axis or chart has a visible title).void
setLogBase
(double value) Sets the base of the logarithm when you are using log scales.void
setMajorTickMark
(TickMark value) Sets the type of major tick mark for the specified axis.void
setMajorUnit
(double value) Sets the major units for the value axis.void
setMajorUnitIsAuto
(boolean value) Sets whether Excel calculates the major units (True if Microsoft Excel calculates the major units for the value axis).void
setMajorUnitScale
(TimeUnit value) Sets the major unit scale value for the category axis when the CategoryType property is set to TimeScale.void
setMaximumScale
(double value) Sets the maximum value on the value axis.void
setMaximumScaleIsAuto
(boolean value) Sets whether Excel calculates the maximum value (True if Microsoft Excel calculates the maximum value for the value axis).void
setMinimumScale
(double value) Sets the minimum value on the value axis.void
setMinimumScaleIsAuto
(boolean value) Sets whether Excel calculates the miniumum value for the value axis (True if Microsoft Excel calculates the minimum value).void
setMinorTickMark
(TickMark value) Sets the type of minor tick mark for the specified axis.void
setMinorUnit
(double value) Sets the minor units on the value axis.void
setMinorUnitIsAuto
(boolean value) Sets whether Microsoft Excel calculates minor units for the value axis (True if Excel calculates minor units).void
setMinorUnitScale
(TimeUnit value) Sets the minor unit scale value for the category axis when theCategoryType
property is set to TimeScale.void
setReversePlotOrder
(boolean value) Sets whether Excel plots data from last to first (True if Microsoft Excel plots data points from last to first).void
setScaleType
(ScaleType value) Sets the value axis scale type.void
Sets the position of tick-mark labels on the specified axis.void
setTickLabelSpacing
(int value) Sets the number of categories or series between tick-mark labels.void
setTickLabelSpacingIsAuto
(boolean value) Sets whether the tick label spacing is automatic.void
setTickMarkSpacing
(int value) Sets s the number of categories or series between tick marks.void
setVisible
(boolean value) Set whether the axis is visible.
-
方法详细资料
-
getAxisBetweenCategories
boolean getAxisBetweenCategories()Gets whether the value axis crosses the category axis (True if the value axis crosses the category axis between categories). -
setAxisBetweenCategories
void setAxisBetweenCategories(boolean value) Sets whether the value axis crosses the category axis (True if the value axis crosses the category axis between categories). -
getAxisGroup
AxisGroup getAxisGroup()Returns the group for the specified axis. -
getAxisTitle
IAxisTitle getAxisTitle()Returns anIAxisTitle
object that represents the title of thespecified axis. -
getBaseUnit
TimeUnit getBaseUnit()Gets the base unit for the specified category axis. -
setBaseUnit
Sets the base unit for the specified category axis. -
getBaseUnitIsAuto
boolean getBaseUnitIsAuto()Gets whether the units are automatically selected (True if Microsoft Excel chooses appropriate base units for the specified category axis). The default value is True. -
setBaseUnitIsAuto
void setBaseUnitIsAuto(boolean value) Sets whether the units are automatically selected (True if Microsoft Excel chooses appropriate base units for the specified category axis). The default value is True. -
getCategoryNames
String[] getCategoryNames()Gets all the category names for the specified axis as a text array. -
setCategoryNames
Sets all the category names for the specified axis as a text array. -
getCategoryType
CategoryType getCategoryType()Gets the category axis type. -
setCategoryType
Sets the category axis type. -
getActualCategoryType
CategoryType getActualCategoryType()Returns the actual category axis type. -
getCrosses
AxisCrosses getCrosses()Gets the point on the specified axis where the other axis crosses. -
setCrosses
Sets the point on the specified axis where the other axis crosses. -
getCrossesAt
double getCrossesAt()Gets the point on the value axis where the category axis crosses it. Applies only to the value axis. -
setCrossesAt
void setCrossesAt(double value) Sets the point on the value axis where the category axis crosses it. Applies only to the value axis. -
getDisplayUnit
DisplayUnit getDisplayUnit()Gets the unit label for the value axis. -
setDisplayUnit
Sets the unit label for the value axis. -
getDisplayUnitCustom
double getDisplayUnitCustom()Gets whether the displayed units use custom settings (If the DisplayUnit property of the is custom, then the DisplayUnitCustom property returns or sets the value of the displayed units. The value must be from 0 through 10E307. -
setDisplayUnitCustom
void setDisplayUnitCustom(double value) Sets whether the displayed units use custom settings (If the DisplayUnit property of the property is custom, then the DisplayUnitCustom property returns or sets the value of the displayed units. The value must be from 0 through 10E307. -
getDisplayUnitLabel
IDisplayUnitLabel getDisplayUnitLabel()Returns theIDisplayUnitLabel
object for the specified axis. ReturnsNull if the HasDisplayUnitLabel property is set to False. -
getFormat
IChartFormat getFormat()Returns theIChartFormat
object. -
getHasDisplayUnitLabel
boolean getHasDisplayUnitLabel()Gets whether the label is displayed on the specified axis (True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis). The default value is True. -
setHasDisplayUnitLabel
void setHasDisplayUnitLabel(boolean value) Sets whether the label is displayed on the specified axis (True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis). The default value is True. -
getHasMajorGridlines
boolean getHasMajorGridlines()Gets whether the axis has major gridlines (True if the axis has major gridlines). This only applies to axes in the primary axis group can have gridlines. -
setHasMajorGridlines
void setHasMajorGridlines(boolean value) Sets whether the axis has major gridlines (True if the axis has major gridlines). This only applies to axes in the primary axis group can have gridlines. -
getHasMinorGridlines
boolean getHasMinorGridlines()Gets whether the axis has minor gridlines (True if the axis has minor gridlines). This only applies to axes in the primary axis group can have gridlines. -
setHasMinorGridlines
void setHasMinorGridlines(boolean value) Sets whether the axis has minor gridlines (True if the axis has minor gridlines). This only applies to axes in the primary axis group can have gridlines. -
getHasTitle
boolean getHasTitle()Gets whether the axis or chart has a visible title (True if the axis or chart has a visible title). -
setHasTitle
void setHasTitle(boolean value) Sets whether the axis or chart has a visible title (True if the axis or chart has a visible title). -
getLogBase
double getLogBase()Gets the base of the logarithm when you are using log scales. -
setLogBase
void setLogBase(double value) Sets the base of the logarithm when you are using log scales. -
getMajorGridlines
IGridlines getMajorGridlines()Returns aIGridlines
object that represents the major gridlines forthe specified axis. Only axes in the primary axis group can have gridlines. -
getMajorTickMark
TickMark getMajorTickMark()Gets the type of major tick mark for the specified axis. -
setMajorTickMark
Sets the type of major tick mark for the specified axis. -
getMajorUnit
double getMajorUnit()Gets the major units for the value axis. -
setMajorUnit
void setMajorUnit(double value) Sets the major units for the value axis. -
getMajorUnitIsAuto
boolean getMajorUnitIsAuto()Gets whether Excel calculates the major units (True if Microsoft Excel calculates the major units for the value axis). -
setMajorUnitIsAuto
void setMajorUnitIsAuto(boolean value) Sets whether Excel calculates the major units (True if Microsoft Excel calculates the major units for the value axis). -
getMajorUnitScale
TimeUnit getMajorUnitScale()Gets the major unit scale value for the category axis when the CategoryType property is set to TimeScale. -
setMajorUnitScale
Sets the major unit scale value for the category axis when the CategoryType property is set to TimeScale. -
getMaximumScale
double getMaximumScale()Gets the maximum value on the value axis. -
setMaximumScale
void setMaximumScale(double value) Sets the maximum value on the value axis. -
getMaximumScaleIsAuto
boolean getMaximumScaleIsAuto()Gets whether Excel calculates the maximum value (True if Microsoft Excel calculates the maximum value for the value axis). -
setMaximumScaleIsAuto
void setMaximumScaleIsAuto(boolean value) Sets whether Excel calculates the maximum value (True if Microsoft Excel calculates the maximum value for the value axis). -
getMinimumScale
double getMinimumScale()Gets the minimum value on the value axis. -
setMinimumScale
void setMinimumScale(double value) Sets the minimum value on the value axis. -
getMinimumScaleIsAuto
boolean getMinimumScaleIsAuto()Gets whether Excel calculates the miniumum value for the value axis (True if Microsoft Excel calculates the minimum value). -
setMinimumScaleIsAuto
void setMinimumScaleIsAuto(boolean value) Sets whether Excel calculates the miniumum value for the value axis (True if Microsoft Excel calculates the minimum value). -
getMinorGridlines
IGridlines getMinorGridlines()Returns theIGridlines
object that represents the minor gridlines forthe specified axis. Only axes in the primary axis group can have gridlines. -
getMinorTickMark
TickMark getMinorTickMark()Gets the type of minor tick mark for the specified axis. -
setMinorTickMark
Sets the type of minor tick mark for the specified axis. -
getMinorUnit
double getMinorUnit()Gets the minor units on the value axis. -
setMinorUnit
void setMinorUnit(double value) Sets the minor units on the value axis. -
getMinorUnitIsAuto
boolean getMinorUnitIsAuto()Gets whether Microsoft Excel calculates minor units for the value axis (True if Excel calculates minor units). -
setMinorUnitIsAuto
void setMinorUnitIsAuto(boolean value) Sets whether Microsoft Excel calculates minor units for the value axis (True if Excel calculates minor units). -
getMinorUnitScale
TimeUnit getMinorUnitScale()Gets the minor unit scale value for the category axis when theCategoryType
property is set to TimeScale. -
setMinorUnitScale
Sets the minor unit scale value for the category axis when theCategoryType
property is set to TimeScale. -
getParent
IAxes getParent()Returns the parent object for the specified object. -
getReversePlotOrder
boolean getReversePlotOrder()Gets whether Excel plots data from last to first (True if Microsoft Excel plots data points from last to first). -
setReversePlotOrder
void setReversePlotOrder(boolean value) Sets whether Excel plots data from last to first (True if Microsoft Excel plots data points from last to first). -
getScaleType
ScaleType getScaleType()Gets the value axis scale type. -
setScaleType
Sets the value axis scale type. -
getTickLabelPosition
TickLabelPosition getTickLabelPosition()Gets the position of tick-mark labels on the specified axis. -
setTickLabelPosition
Sets the position of tick-mark labels on the specified axis. -
getTickLabels
ITickLabels getTickLabels()Returns theITickLabels
object that represents the tick-mark labelsfor the specified axis. -
getTickLabelSpacing
int getTickLabelSpacing()Gets the number of categories or series between tick-mark labels. This only applies to category and series axes. -
setTickLabelSpacing
void setTickLabelSpacing(int value) Sets the number of categories or series between tick-mark labels. This only applies to category and series axes. -
getTickLabelSpacingIsAuto
boolean getTickLabelSpacingIsAuto()Gets whether the tick label spacing is automatic. -
setTickLabelSpacingIsAuto
void setTickLabelSpacingIsAuto(boolean value) Sets whether the tick label spacing is automatic. -
getTickMarkSpacing
int getTickMarkSpacing()Gets s the number of categories or series between tick marks. Applies only to category and series axes. -
setTickMarkSpacing
void setTickMarkSpacing(int value) Sets s the number of categories or series between tick marks. Applies only to category and series axes. -
getType
AxisType getType()Returns the Axis type. -
getVisible
boolean getVisible()Get whether the axis is visible. -
setVisible
void setVisible(boolean value) Set whether the axis is visible.
-