com.aspose.cells
Class Axis

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

public class Axis 
extends java.lang.Object

//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");

public Area getArea()

Gets the Area.

public boolean isAutomaticMinValue() / public void setAutomaticMinValue(boolean value)

Indicates whether the min value is automatically assigned.

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

public boolean isAutomaticMaxValue() / public void setAutomaticMaxValue(boolean value)

Indicates whether the max value is automatically assigned.

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

public boolean isAutomaticMajorUnit() / public void setAutomaticMajorUnit(boolean value)

Indicates whether the major unit of the axis is automatically assigned.

public double getMajorUnit() / public void setMajorUnit(double value)

Represents the major units for the axis.

The major units must be greater than zero.

public boolean isAutomaticMinorUnit() / public void setAutomaticMinorUnit(boolean value)

Indicates whether the minor unit of the axis is automatically assigned.

public double getMinorUnit() / public void setMinorUnit(double value)

Represents the minor units for the axis.

The minor units must be greater than zero.

public Line getAxisLine()

Gets the appearance of an Axis.

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.

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.

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.

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.

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.

public double getLogBase() / public void setLogBase(double value)

Represents the logarithmic base. Default value is 10.Only applies for Excel2007.

public boolean isLogarithmic() / public void setLogarithmic(boolean value)

Represents if the value axis scale type is logarithmic or not.

public boolean isPlotOrderReversed() / public void setPlotOrderReversed(boolean value)

Represents if Microsoft Excel plots data points from last to first.

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.

public TickLabels getTickLabels()

Returns a TickLabels object that represents the tick-mark labels for the specified axis.

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.

public boolean isAutoTickLabelSpacing() / public void setAutoTickLabelSpacing(boolean value)

Indicates whether the spacing of tick label is automatic

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.

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.

public int getCustUnit() / public void setCustUnit(int value)

Specifies a custom value for the display unit.

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.

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.

public Title getTitle()

Gets the axis' title.

public int getCategoryType() / public void setCategoryType(int value)

Represents the category axis type. The value of the property is CategoryType integer constant.

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.

public boolean isBaseUnitAuto() / public void setBaseUnitAuto(boolean value)

Represents whether the base unit is automatic.

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);

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);

public boolean isVisible() / public void setVisible(boolean value)

Represents if the axis is visible.

public Line getMajorGridLines()

Represents major gridlines on a chart axis.

Example:

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

public Line getMinorGridLines()

Represents minor gridlines on a chart axis.

public boolean hasMultiLevelLabels() / public void setHasMultiLevelLabels(boolean value)

Indicates whether the labels shall be shown as multi level.

Only valid for category axis.

public java.util.ArrayList getAxisLabels()

Gets the labels of the axis after call Chart.Calculate() method.

public AxisBins getBins()

Represents bins on a chart(Histogram/Pareto) axis

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.

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.

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.

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.