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
| 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
| 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
| 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
| 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, NotesSlide, BaseSlide, MasterNotesSlide, MasterHandoutSlide
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
| 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. |
| Name | Description |
|---|
| setNumberFormat (String) | Represents the format string for the Axis Labels. Read/write String. |
| 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. |