Axis

Axis class

Encapsulates the object that represents a chart’s axis.

getActualMajorUnit

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

Returns: double

---

getActualMajorUnitScale

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

Returns: int

---

getActualMaxValue

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

Returns: double

---

getActualMinValue

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

Returns: double

---

getActualMinorUnit

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

Returns: double

---

getActualMinorUnitScale

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

Returns: int

---

getAggregationType

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

Returns: int

---

getAxisBetweenCategories

Name	Description
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

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

Returns: int

---

getBinWidth

Name	Description
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

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

Returns: int

---

getChart

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

Returns: Chart

---

getCrossAt

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

Returns: float

---

getCrossType

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

Returns: int

---

getDisplayUnit

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

Returns: int

---

getFormat

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

Returns: AxisFormat

---

getLabelOffset

Name	Description
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

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

Returns: double

---

getMajorGridLinesFormat

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

Returns: ChartLinesFormat

---

getMajorTickMark

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

Returns: int

---

getMajorUnit

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

Returns: double

---

getMajorUnitScale

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

Returns: int

---

getMaxValue

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

Returns: double

---

getMinValue

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

Returns: double

---

getMinorGridLinesFormat

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

Returns: ChartLinesFormat

---

getMinorTickMark

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

Returns: int

---

getMinorUnit

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

Returns: double

---

getMinorUnitScale

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

Returns: int

---

getNumberFormat

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

Returns: String

---

getNumberOfBins

Name	Description
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

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

Returns: double

---

getPosition

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

Returns: int

---

getPresentation

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

Returns: Presentation

---

getShowMajorGridLines

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

Returns: boolean

---

getShowMinorGridLines

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

Returns: boolean

---

getSlide

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

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

---

getTextFormat

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

Returns: ChartTextFormat

---

getTickLabelPosition

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

Returns: int

---

getTickLabelRotationAngle

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

Returns: float

---

getTickLabelSpacing

Name	Description
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

Name	Description
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

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

Returns: ChartTitle

---

getUnderflowBin

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

Returns: double

---

hasTitle

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

Returns: boolean

---

isAutomaticMajorUnit

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

Returns: boolean

---

isAutomaticMaxValue

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

Returns: boolean

---

isAutomaticMinValue

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

Returns: boolean

---

isAutomaticMinorUnit

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

Returns: boolean

---

isAutomaticOverflowBin

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

Returns: boolean

---

isAutomaticTickLabelSpacing

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

Returns: boolean

---

isAutomaticTickMarksSpacing

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

Returns: boolean

---

isAutomaticUnderflowBin

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

Returns: boolean

---

isLogarithmic

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

Returns: boolean

---

isNumberFormatLinkedToSource

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

Returns: boolean

---

isOverflowBin

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

Returns: boolean

---

isPlotOrderReversed

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

Returns: boolean

---

isUnderflowBin

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

Returns: boolean

---

isVisible

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

Returns: boolean

---

setAggregationType

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

---

setAutomaticMajorUnit

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

---

setAutomaticMaxValue

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

---

setAutomaticMinValue

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

---

setAutomaticMinorUnit

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

---

setAutomaticOverflowBin

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

---

setAutomaticTickLabelSpacing

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

---

setAutomaticTickMarksSpacing

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

---

setAutomaticUnderflowBin

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

---

setAxisBetweenCategories

Name	Description
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.

---

setBaseUnitScale

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

---

setBinWidth

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

---

setCategoryAxisType

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

---

setCategoryAxisTypeAutomatically

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

---

setCrossAt

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

---

setCrossType

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

---

setDisplayUnit

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

---

setLabelOffset

Name	Description
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.

---

setLogBase

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

---

setLogarithmic

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

---

setMajorTickMark

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

---

setMajorUnit

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

---

setMajorUnitScale

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

---

setMaxValue

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

---

setMinValue

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

---

setMinorTickMark

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

---

setMinorUnit

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

---

setMinorUnitScale

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

---

setNumberFormat

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

---

setNumberFormatLinkedToSource

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

---

setNumberOfBins

Name	Description
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.

---

setOverflowBin

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

---

setOverflowBin

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

---

setPlotOrderReversed

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

---

setPosition

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

---

setTickLabelPosition

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

---

setTickLabelRotationAngle

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

---

setTickLabelSpacing

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

---

setTickMarksSpacing

Name	Description
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.

---

setTitle

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

---

setUnderflowBin

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

---

setUnderflowBin

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

---

setVisible

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

---