接口 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 an IAxisTitle 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).
    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 the IDisplayUnitLabel object for the specified axis.
    Returns the IChartFormat 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 a IGridlines 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 the IGridlines 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 the CategoryType 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 the ITickLabels 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.
    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
    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
    Sets all the category names for the specified axis as a text array.
    void
    Sets the category axis type.
    void
    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
    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
    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
    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
    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
    Sets the minor unit scale value for the category axis when the CategoryType 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
    Sets the value axis scale type.
    void
    Sets the position of tick-mark labels on the specified axis.
    void
    Sets the number of categories or series between tick-mark labels.
    void
    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 an IAxisTitle object that represents the title of thespecified axis.
    • getBaseUnit

      TimeUnit getBaseUnit()
      Gets the base unit for the specified category axis.
    • setBaseUnit

      void setBaseUnit(TimeUnit value)
      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

      void setCategoryNames(String[] value)
      Sets all the category names for the specified axis as a text array.
    • getCategoryType

      CategoryType getCategoryType()
      Gets the category axis type.
    • setCategoryType

      void setCategoryType(CategoryType value)
      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

      void setCrosses(AxisCrosses value)
      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

      void setDisplayUnit(DisplayUnit value)
      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 the IDisplayUnitLabel object for the specified axis. ReturnsNull if the HasDisplayUnitLabel property is set to False.
    • getFormat

      IChartFormat getFormat()
      Returns the IChartFormat 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 a IGridlines 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

      void setMajorTickMark(TickMark value)
      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

      void setMajorUnitScale(TimeUnit value)
      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 the IGridlines 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

      void setMinorTickMark(TickMark value)
      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 the CategoryType property is set to TimeScale.
    • setMinorUnitScale

      void setMinorUnitScale(TimeUnit value)
      Sets the minor unit scale value for the category axis when the CategoryType 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

      void setScaleType(ScaleType value)
      Sets the value axis scale type.
    • getTickLabelPosition

      TickLabelPosition getTickLabelPosition()
      Gets the position of tick-mark labels on the specified axis.
    • setTickLabelPosition

      void setTickLabelPosition(TickLabelPosition value)
      Sets the position of tick-mark labels on the specified axis.
    • getTickLabels

      ITickLabels getTickLabels()
      Returns the ITickLabels 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.