Axis

Axis class

Encapsulates the object that represents a chart’s axis.

getActualMajorUnit

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

Returns: double

---

getActualMajorUnitScale

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

Returns: int

---

getActualMaxValue

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

Returns: double

---

getActualMinValue

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

Returns: double

---

getActualMinorUnit

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

Returns: double

---

getActualMinorUnitScale

Name	Description
getActualMinorUnitScale ()	Specifies actual minor unit scale of the axis. Call function 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, MasterHandoutSlide, NotesSlide, MasterSlide, MasterNotesSlide, LayoutSlide, BaseSlide

---

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.

---