com.aspose.cells
Classes 
AboveAverage
AbstractCalculationEngine
AbstractCalculationMonitor
AbstractGlobalizationSettings
AbstractInterruptMonitor
AbstractTextLoadOptions
ActiveXControl
ActiveXControlBase
ArcShape
Area
AutoFilter
AutoFitterOptions
AutomaticFill
AutoNumberedBulletValue
Axis
AxisBins
BaseShapeGuide
Bevel
Border
BorderCollection
BuiltInDocumentPropertyCollection
Bullet
BulletValue
Button
CalculationCell
CalculationData
CalculationOptions
Cell
CellArea
Cells
CellsColor
CellsDataTableFactory
CellsDrawing
CellsException
CellsFactory
CellsHelper
CellWatch
CellWatchCollection
CharacterBulletValue
Chart
ChartArea
ChartCollection
ChartDataTable
ChartFrame
ChartGlobalizationSettings
ChartPoint
ChartPointCollection
ChartShape
ChartTextFrame
CheckBox
CheckBoxActiveXControl
CheckBoxCollection
CollectionBase
Color
ColorFilter
ColorHelper
ColorScale
Column
ColumnCollection
ComboBox
ComboBoxActiveXControl
CommandButtonActiveXControl
Comment
CommentCollection
CommentShape
ConditionalFormattingCollection
ConditionalFormattingIcon
ConditionalFormattingIconCollection
ConditionalFormattingResult
ConditionalFormattingValue
ConditionalFormattingValueCollection
ConnectionParameter
ConnectionParameterCollection
ContentTypeProperty
ContentTypePropertyCollection
CopyOptions
CustomDocumentPropertyCollection
CustomFilter
CustomFilterCollection
CustomGeometry
CustomImplementationFactory
CustomProperty
CustomPropertyCollection
CustomXmlPart
CustomXmlPartCollection
CustomXmlShape
DataBar
DataBarBorder
DataLabels
DataSorter
DataSorterKey
DataSorterKeyCollection
DateTime
DateTimeGroupItem
DBConnection
DefaultStyleSettings
DeleteOptions
DialogBox
DifSaveOptions
DigitalSignature
DigitalSignatureCollection
DisplayUnitLabel
DocumentProperty
DocumentPropertyCollection
DocxSaveOptions
DrawObject
DrawObjectEventHandler
DropBars
DxfCollection
DynamicFilter
Encoding
ErrorBar
ErrorCheckOption
ErrorCheckOptionCollection
ExportObjectEvent
ExportRangeToJsonOptions
ExportTableOptions
ExternalConnection
ExternalConnectionCollection
ExternalLink
ExternalLinkCollection
FileFontSource
FileFormatInfo
FileFormatUtil
Fill
FillFormat
FilterColumn
FilterColumnCollection
FindOptions
Floor
FolderFontSource
Font
FontConfigs
FontSetting
FontSettingCollection
FontSourceBase
Format3D
FormatCondition
FormatConditionCollection
FormulaParseOptions
FormulaSettings
Geometry
GlobalizationSettings
GlowEffect
GradientFill
GradientStop
GradientStopCollection
GroupBox
GroupFill
GroupShape
HeaderFooterCommand
HorizontalPageBreak
HorizontalPageBreakCollection
HtmlLoadOptions
HtmlSaveOptions
Hyperlink
HyperlinkCollection
IconFilter
IconSet
ImageActiveXControl
ImageFormat
ImageOrPrintOptions
ImageSaveOptions
ImportTableOptions
IndividualFontConfigs
InsertOptions
InterruptMonitor
JsonLayoutOptions
JsonLoadOptions
JsonSaveOptions
JsonUtility
Label
LabelActiveXControl
Legend
LegendEntry
LegendEntryCollection
License
Line
LineFormat
LineShape
ListBox
ListBoxActiveXControl
ListColumn
ListColumnCollection
ListObject
ListObjectCollection
LoadFilter
LoadOptions
MarkdownSaveOptions
Marker
MemoryFontSource
MetadataOptions
Metered
MsoFillFormat
MsoFillFormatHelper
MsoFormatPicture
MsoLineFormat
MsoLineFormatHelper
MsoTextFrame
MultipleFilterCollection
Name
NameCollection
NegativeBarFormat
NoneBulletValue
NoneFill
OdsCellField
OdsCellFieldCollection
OdsLoadOptions
OdsPageBackground
OdsSaveOptions
OleObject
OleObjectCollection
OoxmlSaveOptions
Outline
Oval
PageEndSavingArgs
PageSavingArgs
PageSetup
PageStartSavingArgs
PaginatedSaveOptions
PaneCollection
PasteOptions
PatternFill
PdfBookmarkEntry
PdfSaveOptions
PdfSecurityOptions
PicFormatOption
Picture
PictureBulletValue
PictureCollection
PivotField
PivotFieldCollection
PivotFilter
PivotFilterCollection
PivotFormatCondition
PivotFormatConditionCollection
PivotItem
PivotItemCollection
PivotOptions
PivotPageFields
PivotTable
PivotTableCollection
PlotArea
PptxSaveOptions
ProtectedRange
ProtectedRangeCollection
Protection
QueryTable
QueryTableCollection
RadioButton
RadioButtonActiveXControl
Range
RangeCollection
RectangleShape
ReferredArea
ReferredAreaCollection
ReflectionEffect
ReplaceOptions
Revision
RevisionAutoFormat
RevisionCellChange
RevisionCellComment
RevisionCellMove
RevisionCollection
RevisionCustomView
RevisionDefinedName
RevisionFormat
RevisionInsertDelete
RevisionInsertSheet
RevisionLog
RevisionLogCollection
RevisionMergeConflict
RevisionQueryTable
RevisionRenameSheet
Row
RowCollection
SaveOptions
Scenario
ScenarioCollection
ScenarioInputCell
ScenarioInputCellCollection
ScrollBar
ScrollBarActiveXControl
Series
SeriesCollection
SeriesLayoutProperties
ShadowEffect
Shape
ShapeCollection
ShapeFormat
ShapeGuide
ShapeGuideCollection
ShapePath
ShapePathCollection
ShapePathPoint
ShapePathPointCollection
ShapePropertyCollection
ShapeSegmentPath
ShapeSegmentPathCollection
ShapeTextAlignment
SheetPrintingPreview
SheetRender
SheetSet
SignatureLine
Slicer
SlicerCache
SlicerCacheItem
SlicerCacheItemCollection
SlicerCollection
SmartArtShape
SmartTag
SmartTagCollection
SmartTagOptions
SmartTagProperty
SmartTagPropertyCollection
SmartTagSetting
SolidFill
Sparkline
SparklineCollection
SparklineGroup
SparklineGroupCollection
SpinButtonActiveXControl
Spinner
SpreadsheetML2003SaveOptions
StreamProviderOptions
Style
StyleFlag
SubtotalSetting
SvgSaveOptions
SxRng
TableStyle
TableStyleCollection
TableStyleElement
TableStyleElementCollection
TableToRangeOptions
TextBox
TextBoxActiveXControl
TextBoxCollection
TextEffectFormat
TextOptions
TextParagraph
TextParagraphCollection
TextTabStop
TextTabStopCollection
TextureFill
ThemeColor
ThreadedComment
ThreadedCommentAuthor
ThreadedCommentAuthorCollection
ThreadedCommentCollection
ThreeDFormat
TickLabelItem
TickLabels
TilePicOption
Timeline
TimelineCollection
Title
ToggleButtonActiveXControl
Top10
Top10Filter
Trendline
TrendlineCollection
TxtLoadOptions
TxtSaveOptions
UnionRange
UnknownControl
Validation
ValidationCollection
VbaModule
VbaModuleCollection
VbaProject
VbaProjectReference
VbaProjectReferenceCollection
VerticalPageBreak
VerticalPageBreakCollection
VmlShapeGuide
Walls
WarningInfo
WebExtension
WebExtensionBinding
WebExtensionBindingCollection
WebExtensionCollection
WebExtensionProperty
WebExtensionPropertyCollection
WebExtensionReference
WebExtensionReferenceCollection
WebExtensionShape
WebExtensionTaskPane
WebExtensionTaskPaneCollection
WebQueryConnection
Workbook
WorkbookDesigner
WorkbookMetadata
WorkbookPrintingPreview
WorkbookRender
WorkbookSettings
Worksheet
WorksheetCollection
WriteProtection
XlsbSaveOptions
XlsSaveOptions
XmlColumnProperty
XmlDataBinding
XmlLoadOptions
XmlMap
XmlMapCollection
XmlSaveOptions
XpsSaveOptions
Interfaces 
ICellsDataTable
ICustomFunction
ICustomParser
IExportObjectListener
IFilePathProvider
IPageSavingCallback
ISmartMarkerCallBack
IStreamProvider
IWarningCallback
LightCellsDataHandler
LightCellsDataProvider
Constants 
AccessCacheOptions
ActiveXPersistenceType
AutoFillType
AutoFitMergedCellsType
AutoFitWrappedTextType
AutoShapeType
AxisType
BackgroundMode
BackgroundType
Bar3DShapeType
BevelPresetType
BevelType
BorderType
BubbleSizeRepresents
BuiltinStyleType
BulletType
CalcModeType
CalculationPrecisionStrategy
CategoryType
CellBorderType
CellValueFormatStrategy
CellValueType
ChartLineFormattingType
ChartMarkerType
ChartSplitType
ChartTextDirectionType
ChartType
CheckValueType
ColorDepth
ColorType
CommentTitleType
ConnectionDataSourceType
ConnectionParameterType
ConsolidationFunction
ControlBorderType
ControlCaptionAlignmentType
ControlListStyle
ControlMatchEntryType
ControlMousePointerType
ControlPictureAlignmentType
ControlPicturePositionType
ControlPictureSizeMode
ControlScrollBarType
ControlScrollOrientation
ControlSpecialEffectType
ControlType
CopyFormatType
CountryCode
CredentialsMethodType
CrossType
DataBarAxisPosition
DataBarBorderType
DataBarFillType
DataBarNegativeColorType
DataLabelShapeType
DataLabelsSeparatorType
DataLablesSeparatorType
DateTimeGroupingType
DefaultEditLanguage
DirectoryType
DisplayDrawingObjects
DisplayUnitType
DrawObjectEnum
DropButtonStyle
DynamicFilterType
EmfRenderSetting
EncryptionType
ErrorBarDisplayType
ErrorBarType
ErrorCheckType
ExceptionType
ExternalLinkType
FileFormatType
FillPattern
FillPictureType
FillType
FilterOperatorType
FilterType
FontSchemeType
FontSourceType
FontUnderlineType
FormatConditionType
FormatConditionValueType
FormatSetType
FormattingType
GradientColorType
GradientDirectionType
GradientFillType
GradientPresetType
GradientStyleType
GridlineType
HeaderFooterCommandType
HtmlCrossType
HtmlExportDataOptions
HtmlFormatHandlingType
HtmlHiddenColDisplayType
HtmlHiddenRowDisplayType
HtmlLinkTargetType
IconSetType
ImageType
InputMethodEditorMode
LabelPositionType
LegendPositionType
LightRigDirectionType
LightRigType
LineCapType
LineJoinType
LineSpaceSizeType
LineType
LoadDataFilterOptions
LoadFormat
LookAtType
LookInType
MapChartLabelLayout
MapChartProjectionType
MapChartRegionType
MemorySetting
MetadataType
MirrorType
MsoArrowheadLength
MsoArrowheadStyle
MsoArrowheadWidth
MsoDrawingType
MsoLineDashStyle
MsoLineStyle
MsoPresetTextEffect
MsoPresetTextEffectShape
NameScopeType
NumberCategoryType
OdsCellFieldType
OdsGeneratorType
OdsPageBackgroundGraphicPositionType
OdsPageBackgroundGraphicType
OdsPageBackgroundType
OLEDBCommandType
OoxmlCompliance
OoxmlCompressionType
OperatorType
PageLayoutAlignmentType
PageOrientationType
PaneStateType
PaperSizeType
ParameterType
PasteOperationType
PasteType
PdfCompliance
PdfCompressionCore
PdfCustomPropertiesExport
PdfFontEncoding
PdfOptimizationType
PivotConditionFormatRuleType
PivotConditionFormatScopeType
PivotFieldDataDisplayFormat
PivotFieldSubtotalType
PivotFieldType
PivotFilterType
PivotGroupByType
PivotItemPosition
PivotMissingItemLimitType
PivotTableAutoFormatType
PivotTableStyleType
PlacementType
PlotDataByType
PlotEmptyCellsType
PresetCameraType
PresetMaterialType
PresetShadowType
PresetWordArtStyle
PrintCommentsType
PrintErrorsType
PrintingPageType
PrintOrderType
PrintSizeType
PropertyType
ProtectionType
QuartileCalculationType
ReConnectionMethodType
RectangleAlignmentType
ReflectionEffectType
RenameStrategy
ResourceLoadingType
RevisionActionType
RevisionType
SaveFormat
SelectionType
ShapeAnchorType
ShapeLockType
ShapePathType
SheetType
ShiftType
ShowDropButtonType
SlicerCacheCrossFilterType
SlicerCacheItemSortType
SlicerStyleType
SmartTagShowType
SortOnType
SortOrder
SparklineAxisMinMaxType
SparklinePresetStyleType
SparklineType
SqlDataType
StyleModifyFlag
TableDataSourceType
TableStyleElementType
TableStyleType
TargetModeType
TextAlignmentType
TextAutonumberScheme
TextCapsType
TextCrossType
TextDirectionType
TextFontAlignType
TextNodeType
TextOrientationType
TextOverflowType
TextStrikeType
TextTabAlignmentType
TextureType
TextVerticalType
ThemeColorType
TickLabelPositionType
TickMarkType
TiffCompression
TimePeriodType
TimeUnit
TotalsCalculation
TrendlineType
TxtLoadStyleStrategy
TxtValueQuoteType
UpdateLinksType
ValidationAlertType
ValidationType
VbaModuleType
VbaProjectReferenceType
ViewType
VisibilityType
WarningType
WebExtensionStoreType
WeightType
XAdESType

com.aspose.cells
Class Axis

java.lang.Object
    extended by com.aspose.cells.Axis

public class Axis 
extends java.lang.Object

Encapsulates the object that represents a chart's axis.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Excel object
int sheetIndex = workbook.getWorksheets().add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
//Adding a sample value to "A1" cell
worksheet.getCells().get("A1").putValue(50);
//Adding a sample value to "A2" cell
worksheet.getCells().get("A2").putValue(100);
//Adding a sample value to "A3" cell
worksheet.getCells().get("A3").putValue(150);
//Adding a sample value to "B1" cell
worksheet.getCells().get("B1").putValue(4);
//Adding a sample value to "B2" cell
worksheet.getCells().get("B2").putValue(20);
//Adding a sample value to "B3" cell
worksheet.getCells().get("B3").putValue(50);
//Adding a chart to the worksheet
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 25, 5);
//Accessing the instance of the newly added chart
Chart chart = worksheet.getCharts().get(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
chart.getNSeries().add("A1:B3", true);
//Set the max value of value axis
chart.getValueAxis().setMaxValue(200);
//Set the min value of value axis
chart.getValueAxis().setMinValue(0);
//Set the major unit
chart.getValueAxis().setMajorUnit(25);
//Category(X) axis crosses at the maxinum value.
chart.getValueAxis().setCrossType(CrossType.MAXIMUM);
//Set he number of categories or series between tick-mark labels. 
chart.getCategoryAxis().setTickLabelSpacing(2);

//do your business

//Saving the Excel file
workbook.save("book1.xlsx");


Property Getters/Setters Summary
AreagetArea()
           Gets the Area.
booleangetAxisBetweenCategories()
voidsetAxisBetweenCategories(boolean)
           Represents if the value axis crosses the category axis between categories.
java.util.ArrayListgetAxisLabels()
           Gets the labels of the axis after call Chart.Calculate() method.
LinegetAxisLine()
           Gets the appearance of an Axis.
intgetBaseUnitScale()
voidsetBaseUnitScale(int)
           Represents the base unit scale for the category axis. The value of the property is TimeUnit integer constant.
AxisBinsgetBins()
           Represents bins on a chart(Histogram/Pareto) axis
intgetCategoryType()
voidsetCategoryType(int)
           Represents the category axis type. The value of the property is CategoryType integer constant.
doublegetCrossAt()
voidsetCrossAt(double)
           Represents the point on the value axis where the category axis crosses it.
intgetCrossType()
voidsetCrossType(int)
           Represents the CrossType on the specified axis where the other axis crosses. The value of the property is CrossType integer constant.
intgetCustUnit()
voidsetCustUnit(int)
           Specifies a custom value for the display unit.
intgetDisplayUnit()
voidsetDisplayUnit(int)
           Represents the unit label for the specified axis. The value of the property is DisplayUnitType integer constant.
DisplayUnitLabelgetDisplayUnitLabel()
           Represents a unit label on an axis in the specified chart. Unit labels are useful for charting large values— for example, in the millions or billions.
booleanhasMultiLevelLabels()
voidsetHasMultiLevelLabels(boolean)
           Indicates whether the labels shall be shown as multi level.
booleanisAutomaticMajorUnit()
voidsetAutomaticMajorUnit(boolean)
           Indicates whether the major unit of the axis is automatically assigned.
booleanisAutomaticMaxValue()
voidsetAutomaticMaxValue(boolean)
           Indicates whether the max value is automatically assigned.
booleanisAutomaticMinorUnit()
voidsetAutomaticMinorUnit(boolean)
           Indicates whether the minor unit of the axis is automatically assigned.
booleanisAutomaticMinValue()
voidsetAutomaticMinValue(boolean)
           Indicates whether the min value is automatically assigned.
booleanisAutoTickLabelSpacing()
voidsetAutoTickLabelSpacing(boolean)
           Indicates whether the spacing of tick label is automatic
booleanisBaseUnitAuto()
voidsetBaseUnitAuto(boolean)
           Represents whether the base unit is automatic.
booleanisDisplayUnitLabelShown()
voidsetDisplayUnitLabelShown(boolean)
           Represents if the display unit label is shown on the specified axis.
booleanisLogarithmic()
voidsetLogarithmic(boolean)
           Represents if the value axis scale type is logarithmic or not.
booleanisPlotOrderReversed()
voidsetPlotOrderReversed(boolean)
           Represents if Microsoft Excel plots data points from last to first.
booleanisVisible()
voidsetVisible(boolean)
           Represents if the axis is visible.
doublegetLogBase()
voidsetLogBase(double)
           Represents the logarithmic base. Default value is 10.Only applies for Excel2007.
LinegetMajorGridLines()
           Represents major gridlines on a chart axis.
intgetMajorTickMark()
voidsetMajorTickMark(int)
           Represents the type of major tick mark for the specified axis. The value of the property is TickMarkType integer constant.
doublegetMajorUnit()
voidsetMajorUnit(double)
           Represents the major units for the axis.
intgetMajorUnitScale()
voidsetMajorUnitScale(int)
           Represents the major unit scale for the category axis. The value of the property is TimeUnit integer constant.
java.lang.ObjectgetMaxValue()
voidsetMaxValue(java.lang.Object)
           Represents the maximum value on the value axis.
LinegetMinorGridLines()
           Represents minor gridlines on a chart axis.
intgetMinorTickMark()
voidsetMinorTickMark(int)
           Represents the type of minor tick mark for the specified axis. The value of the property is TickMarkType integer constant.
doublegetMinorUnit()
voidsetMinorUnit(double)
           Represents the minor units for the axis.
intgetMinorUnitScale()
voidsetMinorUnitScale(int)
           Represents the major unit scale for the category axis. The value of the property is TimeUnit integer constant.
java.lang.ObjectgetMinValue()
voidsetMinValue(java.lang.Object)
           Represents the minimum value on the value axis.
intgetTickLabelPosition()
voidsetTickLabelPosition(int)
           Represents the position of tick-mark labels on the specified axis. The value of the property is TickLabelPositionType integer constant.
TickLabelsgetTickLabels()
           Returns a TickLabels object that represents the tick-mark labels for the specified axis.
intgetTickLabelSpacing()
voidsetTickLabelSpacing(int)
           Represents the number of categories or series between tick-mark labels. Applies only to category and series axes.
intgetTickMarkSpacing()
voidsetTickMarkSpacing(int)
           Returns or sets the number of categories or series between tick marks. Applies only to category and series axes.
TitlegetTitle()
           Gets the axis' title.
 
Method Summary
booleanisAutoCross()
           Indicates whether Microsoft Workbook automatically sets the axis crossing point.
booleanisCrossAtMax()
           Indicates whether Microsoft Workbook automatically sets the axis crossing point.
voidsetAutoCross()
           Sets the axis crossing point as automatic.
voidsetCrossAtMax(boolean isCrossAtMax)
           Sets whether the axis crosses at the maximum value.
 

Property Getters/Setters Detail

getArea

public Area getArea()
Gets the Area.

isAutomaticMinValue/setAutomaticMinValue

public boolean isAutomaticMinValue() / public void setAutomaticMinValue(boolean value)
Indicates whether the min value is automatically assigned.

getMinValue/setMinValue

public java.lang.Object getMinValue() / public void setMinValue(java.lang.Object value)
Represents the minimum value on the value axis. The minValue type only can be double or DateTime

isAutomaticMaxValue/setAutomaticMaxValue

public boolean isAutomaticMaxValue() / public void setAutomaticMaxValue(boolean value)
Indicates whether the max value is automatically assigned.

getMaxValue/setMaxValue

public java.lang.Object getMaxValue() / public void setMaxValue(java.lang.Object value)
Represents the maximum value on the value axis. The maxValue type only can be double or DateTime

isAutomaticMajorUnit/setAutomaticMajorUnit

public boolean isAutomaticMajorUnit() / public void setAutomaticMajorUnit(boolean value)
Indicates whether the major unit of the axis is automatically assigned.

getMajorUnit/setMajorUnit

public double getMajorUnit() / public void setMajorUnit(double value)
Represents the major units for the axis. The major units must be greater than zero.

isAutomaticMinorUnit/setAutomaticMinorUnit

public boolean isAutomaticMinorUnit() / public void setAutomaticMinorUnit(boolean value)
Indicates whether the minor unit of the axis is automatically assigned.

getMinorUnit/setMinorUnit

public double getMinorUnit() / public void setMinorUnit(double value)
Represents the minor units for the axis. The minor units must be greater than zero.

getAxisLine

public Line getAxisLine()
Gets the appearance of an Axis.

getMajorTickMark/setMajorTickMark

public int getMajorTickMark() / public void setMajorTickMark(int value)
Represents the type of major tick mark for the specified axis. The value of the property is TickMarkType integer constant.

getMinorTickMark/setMinorTickMark

public int getMinorTickMark() / public void setMinorTickMark(int value)
Represents the type of minor tick mark for the specified axis. The value of the property is TickMarkType integer constant.

getTickLabelPosition/setTickLabelPosition

public int getTickLabelPosition() / public void setTickLabelPosition(int value)
Represents the position of tick-mark labels on the specified axis. The value of the property is TickLabelPositionType integer constant.

getCrossAt/setCrossAt

public double getCrossAt() / public void setCrossAt(double value)
Represents the point on the value axis where the category axis crosses it. The number should be a integer when it applies to category axis. And the value must be between 1 and 31999.

getCrossType/setCrossType

public int getCrossType() / public void setCrossType(int value)
Represents the CrossType on the specified axis where the other axis crosses. The value of the property is CrossType integer constant.

getLogBase/setLogBase

public double getLogBase() / public void setLogBase(double value)
Represents the logarithmic base. Default value is 10.Only applies for Excel2007.

isLogarithmic/setLogarithmic

public boolean isLogarithmic() / public void setLogarithmic(boolean value)
Represents if the value axis scale type is logarithmic or not.

isPlotOrderReversed/setPlotOrderReversed

public boolean isPlotOrderReversed() / public void setPlotOrderReversed(boolean value)
Represents if Microsoft Excel plots data points from last to first.

getAxisBetweenCategories/setAxisBetweenCategories

public boolean getAxisBetweenCategories() / public void setAxisBetweenCategories(boolean value)
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.

getTickLabels

public TickLabels getTickLabels()
Returns a TickLabels object that represents the tick-mark labels for the specified axis.

getTickLabelSpacing/setTickLabelSpacing

public int getTickLabelSpacing() / public void setTickLabelSpacing(int value)
Represents the number of categories or series between tick-mark labels. Applies only to category and series axes. The number must be between 1 and 31999.

isAutoTickLabelSpacing/setAutoTickLabelSpacing

public boolean isAutoTickLabelSpacing() / public void setAutoTickLabelSpacing(boolean value)
Indicates whether the spacing of tick label is automatic

getTickMarkSpacing/setTickMarkSpacing

public int getTickMarkSpacing() / public void setTickMarkSpacing(int value)
Returns or sets the number of categories or series between tick marks. Applies only to category and series axes. The number must be between 1 and 31999.

getDisplayUnit/setDisplayUnit

public int getDisplayUnit() / public void setDisplayUnit(int value)
Represents the unit label for the specified axis. The value of the property is DisplayUnitType integer constant.

getCustUnit/setCustUnit

public int getCustUnit() / public void setCustUnit(int value)
Specifies a custom value for the display unit.

getDisplayUnitLabel

public DisplayUnitLabel getDisplayUnitLabel()
Represents a unit label on an axis in the specified chart. Unit labels are useful for charting large values— for example, in the millions or billions.

isDisplayUnitLabelShown/setDisplayUnitLabelShown

public boolean isDisplayUnitLabelShown() / public void setDisplayUnitLabelShown(boolean value)
Represents if the display unit label is shown on the specified axis. The default value is True.

getTitle

public Title getTitle()
Gets the axis' title.

getCategoryType/setCategoryType

public int getCategoryType() / public void setCategoryType(int value)
Represents the category axis type. The value of the property is CategoryType integer constant.

getBaseUnitScale/setBaseUnitScale

public int getBaseUnitScale() / public void setBaseUnitScale(int value)
Represents the base unit scale for the category axis. The value of the property is TimeUnit integer constant.Setting this property only takes effect when the CategoryType property is set to TimeScale.

isBaseUnitAuto/setBaseUnitAuto

public boolean isBaseUnitAuto() / public void setBaseUnitAuto(boolean value)
Represents whether the base unit is automatic.

getMajorUnitScale/setMajorUnitScale

public int getMajorUnitScale() / public void setMajorUnitScale(int value)
Represents the major unit scale for the category axis. The value of the property is TimeUnit integer constant.

Example:

chart.getCategoryAxis().setCategoryType(CategoryType.TIME_SCALE);
chart.getCategoryAxis().setMajorUnitScale(TimeUnit.MONTHS);
chart.getCategoryAxis().setMajorUnit(2);

getMinorUnitScale/setMinorUnitScale

public int getMinorUnitScale() / public void setMinorUnitScale(int value)
Represents the major unit scale for the category axis. The value of the property is TimeUnit integer constant.

Example:

chart.getCategoryAxis().setCategoryType(CategoryType.TIME_SCALE);
chart.getCategoryAxis().setMinorUnitScale(TimeUnit.MONTHS);
chart.getCategoryAxis().setMinorUnit(2);

isVisible/setVisible

public boolean isVisible() / public void setVisible(boolean value)
Represents if the axis is visible.

getMajorGridLines

public Line getMajorGridLines()
Represents major gridlines on a chart axis.

Example:

chart.getValueAxis().getMajorGridLines().setVisible(false);
chart.getCategoryAxis().getMajorGridLines().setVisible(true);

getMinorGridLines

public Line getMinorGridLines()
Represents minor gridlines on a chart axis.

hasMultiLevelLabels/setHasMultiLevelLabels

public boolean hasMultiLevelLabels() / public void setHasMultiLevelLabels(boolean value)
Indicates whether the labels shall be shown as multi level. Only valid for category axis.

getAxisLabels

public java.util.ArrayList getAxisLabels()
Gets the labels of the axis after call Chart.Calculate() method.

getBins

public AxisBins getBins()
Represents bins on a chart(Histogram/Pareto) axis

Method Detail

isAutoCross

public boolean isAutoCross()
Indicates whether Microsoft Workbook automatically sets the axis crossing point. NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Charts.Axis.CrossType property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

isCrossAtMax

public boolean isCrossAtMax()
Indicates whether Microsoft Workbook automatically sets the axis crossing point. NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Charts.Axis.CrossType property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

setAutoCross

public void setAutoCross()
Sets the axis crossing point as automatic. NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Charts.Axis.CrossType property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

setCrossAtMax

public void setCrossAtMax(boolean isCrossAtMax)
Sets whether the axis crosses at the maximum value. NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Charts.Axis.CrossType property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.