Axis

Axis class

Encapsulates the object that represents a chart’s axis.

getActualMajorUnit

NameDescription
getActualMajorUnit ()Specifies actual major unit of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.

Returns: double


getActualMajorUnitScale

NameDescription
getActualMajorUnitScale ()Specifies actual major unit scale of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.

Returns: int


getActualMaxValue

NameDescription
getActualMaxValue ()Specifies actual maximum value on the axis. Call method IChart.ValidateChartLayout() previously to get actual value.

Returns: double


getActualMinValue

NameDescription
getActualMinValue ()Specifies actual minimum value on the axis. Call method IChart.ValidateChartLayout() previously to get actual value.

Returns: double


getActualMinorUnit

NameDescription
getActualMinorUnit ()Specifies actual minor unit of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.

Returns: double


getActualMinorUnitScale

NameDescription
getActualMinorUnitScale ()Specifies actual minor unit scale of the axis. Call method IChart.ValidateChartLayout() previously to get actual value.

Returns: int


getAggregationType

NameDescription
getAggregationType ()Represents aggregation type of category axis (binning). Applied to category. Used with Histogram or HistogramPareto series only.

Returns: int


getAxisBetweenCategories

NameDescription
getAxisBetweenCategories ()Represents if the value axis crosses the category axis between categories. This property applies only to category axes, and it doesn’t apply to 3-D charts. Read/write boolean.

Returns: boolean


getBaseUnitScale

NameDescription
getBaseUnitScale ()Specifies the smallest time unit that is represented on the date axis. Read/write TimeUnitType.

Returns: int


getBinWidth

NameDescription
getBinWidth ()Specifies bin width when AggregationType property value setted to AxisAggregationType.ByBinWidth. Applied to category axes. Used with Histogram or HistogramPareto series only.

Returns: double


getCategoryAxisType

NameDescription
getCategoryAxisType ()Specifies the type of the category axis. Read/write CategoryAxisType.

Returns: int


getChart

NameDescription
getChart ()Returns the parent chart. Read-only IChart.

Returns: Chart


getCrossAt

NameDescription
getCrossAt ()Represents the point on the axis where the perpendicular axis crosses it. Read/write float.

Returns: float


getCrossType

NameDescription
getCrossType ()Represents the CrossType on the specified axis where the other axis crosses. Read/write CrossesType.

Returns: int


getDisplayUnit

NameDescription
getDisplayUnit ()Specifies the scaling value of the display units for the value axis. Read/write DisplayUnitType.

Returns: int


getFormat

NameDescription
getFormat ()Represents format of axis. Read-only IAxisFormat.

Returns: AxisFormat


getLabelOffset

NameDescription
getLabelOffset ()Specifies the distance of labels from the axis. Applied to category or date axis. Value must be between 0% and 1000%. Read/write int.

Returns: int


getLogBase

NameDescription
getLogBase ()Represents the logarithmic base. Default value is 10. Read/write double.

Returns: double


getMajorGridLinesFormat

NameDescription
getMajorGridLinesFormat ()Represents major gridlines format on a chart axis. Read-only IChartLinesFormat.

Returns: ChartLinesFormat


getMajorTickMark

NameDescription
getMajorTickMark ()Represents the type of major tick mark for the specified axis. Read/write TickMarkType.

Returns: int


getMajorUnit

NameDescription
getMajorUnit ()Represents the major units for the date or value axis. Read/write double.

Returns: double


getMajorUnitScale

NameDescription
getMajorUnitScale ()Represents the major unit scale for the date axis. Read/write TimeUnitType.

Returns: int


getMaxValue

NameDescription
getMaxValue ()Represents the maximum value on the value axis. Read/write double.

Returns: double


getMinValue

NameDescription
getMinValue ()Represents the minimum value on the value axis. Read/write double.

Returns: double


getMinorGridLinesFormat

NameDescription
getMinorGridLinesFormat ()Represents minor gridlines format on a chart axis. Read-only IChartLinesFormat.

Returns: ChartLinesFormat


getMinorTickMark

NameDescription
getMinorTickMark ()Represents the type of minor tick mark for the specified axis. Read/write TickMarkType.

Returns: int


getMinorUnit

NameDescription
getMinorUnit ()Represents the minor units for the date or value axis. Read/write double.

Returns: double


getMinorUnitScale

NameDescription
getMinorUnitScale ()Represents the major unit scale for the date axis. Read/write TimeUnitType.

Returns: int


getNumberFormat

NameDescription
getNumberFormat ()Represents the format string for the Axis Labels. Read/write String.

Returns: String


getNumberOfBins

NameDescription
getNumberOfBins ()Specifies number of bins when AggregationType property value setted to AxisAggregationType.ByNumberOfBins. Applied to category axes. Used with Histogram or HistogramPareto series only.

Returns: long


getOverflowBin

NameDescription
getOverflowBin ()Specifies overflow bin custom value. Applied when IsAutomaticOverflowBin property setted to false and IsOverflowBin property equals true.

Returns: double


getPosition

NameDescription
getPosition ()Represents position of axis. Read/write AxisPositionType.

Returns: int


getPresentation

NameDescription
getPresentation ()Returns the parent presentation of a FillFormat. Read-only IPresentation.

Returns: Presentation


getShowMajorGridLines

NameDescription
getShowMajorGridLines ()To hide major gridline set MajorGridLinesFormat.Line.FillFormat.FillType to FillType.NoFill. Read-only boolean.

Returns: boolean


getShowMinorGridLines

NameDescription
getShowMinorGridLines ()To hide minor gridline set MinorGridLinesFormat.Line.FillFormat.FillType to FillType.NoFill. Read-only boolean.

Returns: boolean


getSlide

NameDescription
getSlide ()Returns the parent slide of a FillFormat. Read-only BaseSlide.

Returns: MasterHandoutSlide, BaseSlide, LayoutSlide, Slide, MasterSlide, NotesSlide, MasterNotesSlide


getTextFormat

NameDescription
getTextFormat ()Represents format of text. Read-only IChartTextFormat.

Returns: ChartTextFormat


getTickLabelPosition

NameDescription
getTickLabelPosition ()Represents the position of tick-mark labels on the specified axis. Read/write TickLabelPositionType.

Returns: int


getTickLabelRotationAngle

NameDescription
getTickLabelRotationAngle ()Represents the rotation angle of tick labels. Read/write float.

Returns: float


getTickLabelSpacing

NameDescription
getTickLabelSpacing ()Specifies how many tick labels to skip between label that is drawn. Applied to category or series axis. Read/write long.

Returns: long


getTickMarksSpacing

NameDescription
getTickMarksSpacing ()Specifies how many tick marks shall be skipped before the next one shall be drawn. Applied to category or series axis. Read/write int.

Returns: long


getTitle

NameDescription
getTitle ()Gets the axis’ title. Read-only IChartTitle.

Returns: ChartTitle


getUnderflowBin

NameDescription
getUnderflowBin ()Specifies underflow bin custom value. Applied when IsAutomaticUnderflowBin property setted to false and IsUnderflowBin property equals true.

Returns: double


hasTitle

NameDescription
hasTitle ()Determines whether a axis has a visible title. Read/write boolean.

Returns: boolean


isAutomaticMajorUnit

NameDescription
isAutomaticMajorUnit ()Indicates whether the major unit of the axis is automatically assigned. Read/write boolean.

Returns: boolean


isAutomaticMaxValue

NameDescription
isAutomaticMaxValue ()Indicates whether the max value is automatically assigned. Read/write boolean.

Returns: boolean


isAutomaticMinValue

NameDescription
isAutomaticMinValue ()Indicates whether the min value is automatically assigned. Read/write boolean.

Returns: boolean


isAutomaticMinorUnit

NameDescription
isAutomaticMinorUnit ()Indicates whether the minor unit of the axis is automatically assigned. Read/write boolean.

Returns: boolean


isAutomaticOverflowBin

NameDescription
isAutomaticOverflowBin ()Specifies automatic overflow bin value. If false: use OverflowBin property.

Returns: boolean


isAutomaticTickLabelSpacing

NameDescription
isAutomaticTickLabelSpacing ()Specifies automatic tick label spacing value. If false: use TickLabelSpacing property. Read/write boolean.

Returns: boolean


isAutomaticTickMarksSpacing

NameDescription
isAutomaticTickMarksSpacing ()Specifies automatic tick marks spacing value. If false: use TickMarksSpacing property. Read/write boolean.

Returns: boolean


isAutomaticUnderflowBin

NameDescription
isAutomaticUnderflowBin ()Specifies automatic underflow bin value. If false: use UnderflowBin property.

Returns: boolean


isLogarithmic

NameDescription
isLogarithmic ()Represents if the value axis scale type is logarithmic or not. Read/write boolean.

Returns: boolean


isNumberFormatLinkedToSource

NameDescription
isNumberFormatLinkedToSource ()Indicates whether the format is linked source data. Read/write boolean.

Returns: boolean


isOverflowBin

NameDescription
isOverflowBin ()Specifies if overflow bin applied. Use IsAutomaticOverflowBin and OverflowBin to adjust overflow bin value.

Returns: boolean


isPlotOrderReversed

NameDescription
isPlotOrderReversed ()Represents if MS PowerPoint plots data points from last to first. Read/write boolean.

Returns: boolean


isUnderflowBin

NameDescription
isUnderflowBin ()Specifies if underflow bin applied. Use IsAutomaticUnderflowBin and UnderflowBin to adjust underflow bin value.

Returns: boolean


isVisible

NameDescription
isVisible ()Represents if the axis is visible. Read/write boolean.

Returns: boolean


setAggregationType

NameDescription
setAggregationType (int)Represents aggregation type of category axis (binning). Applied to category. Used with Histogram or HistogramPareto series only.

Returns: void


setAutomaticMajorUnit

NameDescription
setAutomaticMajorUnit (boolean)Indicates whether the major unit of the axis is automatically assigned. Read/write boolean.

Returns: void


setAutomaticMaxValue

NameDescription
setAutomaticMaxValue (boolean)Indicates whether the max value is automatically assigned. Read/write boolean.

Returns: void


setAutomaticMinValue

NameDescription
setAutomaticMinValue (boolean)Indicates whether the min value is automatically assigned. Read/write boolean.

Returns: void


setAutomaticMinorUnit

NameDescription
setAutomaticMinorUnit (boolean)Indicates whether the minor unit of the axis is automatically assigned. Read/write boolean.

Returns: void


setAutomaticOverflowBin

NameDescription
setAutomaticOverflowBin (boolean)Specifies automatic overflow bin value. If false: use OverflowBin property.

Returns: void


setAutomaticTickLabelSpacing

NameDescription
setAutomaticTickLabelSpacing (boolean)Specifies automatic tick label spacing value. If false: use TickLabelSpacing property. Read/write boolean.

Returns: void


setAutomaticTickMarksSpacing

NameDescription
setAutomaticTickMarksSpacing (boolean)Specifies automatic tick marks spacing value. If false: use TickMarksSpacing property. Read/write boolean.

Returns: void


setAutomaticUnderflowBin

NameDescription
setAutomaticUnderflowBin (boolean)Specifies automatic underflow bin value. If false: use UnderflowBin property.

Returns: void


setAxisBetweenCategories

NameDescription
setAxisBetweenCategories (boolean)Represents if the value axis crosses the category axis between categories. This property applies only to category axes, and it doesn’t apply to 3-D charts. Read/write boolean.

Returns: void


setBaseUnitScale

NameDescription
setBaseUnitScale (int)Specifies the smallest time unit that is represented on the date axis. Read/write TimeUnitType.

Returns: void


setBinWidth

NameDescription
setBinWidth (double)Specifies bin width when AggregationType property value setted to AxisAggregationType.ByBinWidth. Applied to category axes. Used with Histogram or HistogramPareto series only.

Returns: void


setCategoryAxisType

NameDescription
setCategoryAxisType (int)Specifies the type of the category axis. Read/write CategoryAxisType.

Returns: void


setCategoryAxisTypeAutomatically

NameDescription
setCategoryAxisTypeAutomatically ()Sets IAxis.CategoryAxisType property with a value that is automatically determined based on axis data.

Returns: void


setCrossAt

NameDescription
setCrossAt (float)Represents the point on the axis where the perpendicular axis crosses it. Read/write float.

Returns: void


setCrossType

NameDescription
setCrossType (int)Represents the CrossType on the specified axis where the other axis crosses. Read/write CrossesType.

Returns: void


setDisplayUnit

NameDescription
setDisplayUnit (int)Specifies the scaling value of the display units for the value axis. Read/write DisplayUnitType.

Returns: void


setLabelOffset

NameDescription
setLabelOffset (int)Specifies the distance of labels from the axis. Applied to category or date axis. Value must be between 0% and 1000%. Read/write int.

Returns: void


setLogBase

NameDescription
setLogBase (double)Represents the logarithmic base. Default value is 10. Read/write double.

Returns: void


setLogarithmic

NameDescription
setLogarithmic (boolean)Represents if the value axis scale type is logarithmic or not. Read/write boolean.

Returns: void


setMajorTickMark

NameDescription
setMajorTickMark (int)Represents the type of major tick mark for the specified axis. Read/write TickMarkType.

Returns: void


setMajorUnit

NameDescription
setMajorUnit (double)Represents the major units for the date or value axis. Read/write double.

Returns: void


setMajorUnitScale

NameDescription
setMajorUnitScale (int)Represents the major unit scale for the date axis. Read/write TimeUnitType.

Returns: void


setMaxValue

NameDescription
setMaxValue (double)Represents the maximum value on the value axis. Read/write double.

Returns: void


setMinValue

NameDescription
setMinValue (double)Represents the minimum value on the value axis. Read/write double.

Returns: void


setMinorTickMark

NameDescription
setMinorTickMark (int)Represents the type of minor tick mark for the specified axis. Read/write TickMarkType.

Returns: void


setMinorUnit

NameDescription
setMinorUnit (double)Represents the minor units for the date or value axis. Read/write double.

Returns: void


setMinorUnitScale

NameDescription
setMinorUnitScale (int)Represents the major unit scale for the date axis. Read/write TimeUnitType.

Returns: void


setNumberFormat

NameDescription
setNumberFormat (String)Represents the format string for the Axis Labels. Read/write String.

Returns: void


setNumberFormatLinkedToSource

NameDescription
setNumberFormatLinkedToSource (boolean)Indicates whether the format is linked source data. Read/write boolean.

Returns: void


setNumberOfBins

NameDescription
setNumberOfBins (long)Specifies number of bins when AggregationType property value setted to AxisAggregationType.ByNumberOfBins. Applied to category axes. Used with Histogram or HistogramPareto series only.

Returns: void


setOverflowBin

NameDescription
setOverflowBin (boolean)Specifies if overflow bin applied. Use IsAutomaticOverflowBin and OverflowBin to adjust overflow bin value.

Returns: void


setOverflowBin

NameDescription
setOverflowBin (double)Specifies overflow bin custom value. Applied when IsAutomaticOverflowBin property setted to false and IsOverflowBin property equals true.

Returns: void


setPlotOrderReversed

NameDescription
setPlotOrderReversed (boolean)Represents if MS PowerPoint plots data points from last to first. Read/write boolean.

Returns: void


setPosition

NameDescription
setPosition (int)Represents position of axis. Read/write AxisPositionType.

Returns: void


setTickLabelPosition

NameDescription
setTickLabelPosition (int)Represents the position of tick-mark labels on the specified axis. Read/write TickLabelPositionType.

Returns: void


setTickLabelRotationAngle

NameDescription
setTickLabelRotationAngle (float)Represents the rotation angle of tick labels. Read/write float.

Returns: void


setTickLabelSpacing

NameDescription
setTickLabelSpacing (long)Specifies how many tick labels to skip between label that is drawn. Applied to category or series axis. Read/write long.

Returns: void


setTickMarksSpacing

NameDescription
setTickMarksSpacing (long)Specifies how many tick marks shall be skipped before the next one shall be drawn. Applied to category or series axis. Read/write int.

Returns: void


setTitle

NameDescription
setTitle (boolean)Determines whether a axis has a visible title. Read/write boolean.

Returns: void


setUnderflowBin

NameDescription
setUnderflowBin (boolean)Specifies if underflow bin applied. Use IsAutomaticUnderflowBin and UnderflowBin to adjust underflow bin value.

Returns: void


setUnderflowBin

NameDescription
setUnderflowBin (double)Specifies underflow bin custom value. Applied when IsAutomaticUnderflowBin property setted to false and IsUnderflowBin property equals true.

Returns: void


setVisible

NameDescription
setVisible (boolean)Represents if the axis is visible. Read/write boolean.

Returns: void