com.aspose.cells
Class ErrorBar

java.lang.Object
  extended by Line
      extended by com.aspose.cells.ErrorBar

public class ErrorBar 
extends Line

Represents error bar of data series.

Example:

Workbook workbook = new Workbook();
Cells cells = workbook.getWorksheets().get(0).getCells();
cells.get("a1").putValue(2);
cells.get("a2").putValue(5);
cells.get("a3").putValue(3);
cells.get("a4").putValue(6);
cells.get("b1").putValue(4);
cells.get("b2").putValue(3);
cells.get("b3").putValue(6);
cells.get("b4").putValue(7);
 
cells.get("C1").putValue("Q1");
cells.get("C2").putValue("Q2");
cells.get("C3").putValue("Y1");
cells.get("C4").putValue("Y2");
 
int chartIndex = workbook.getWorksheets().get(0).getCharts().add(ChartType.COLUMN, 11, 0, 27, 10);
 
Chart chart = workbook.getWorksheets().get(0).getCharts().get(chartIndex);
chart.getNSeries().add("A1:B4", true);
 
chart.getNSeries().setCategoryData("C1:C4");

for (int i = 0; i < chart.getNSeries().getCount(); i++)
{
    Series aseries = chart.getNSeries().get(i);
    aseries.getXErrorBar().setDisplayType(ErrorBarDisplayType.MINUS);
    aseries.getXErrorBar().setType(ErrorBarType.FIXED_VALUE);
    aseries.getXErrorBar().setAmount(5);
}

Property Getters/Setters Summary
doublegetAmount()
voidsetAmount(double value)
           Represents amount of error bar. The amount must be greater than and equal to zero.
intgetBeginArrowLength()→ inherited from Line
voidsetBeginArrowLength(int value)
           Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.
intgetBeginArrowWidth()→ inherited from Line
voidsetBeginArrowWidth(int value)
           Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.
intgetBeginType()→ inherited from Line
voidsetBeginType(int value)
           Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.
intgetCapType()→ inherited from Line
voidsetCapType(int value)
           Specifies the ending caps. The value of the property is LineCapType integer constant.
ColorgetColor()→ inherited from Line
voidsetColor(Color value)
           Represents the com.aspose.cells.Color of the line.
intgetCompoundType()→ inherited from Line
voidsetCompoundType(int value)
           Specifies the compound line type The value of the property is MsoLineStyle integer constant.
intgetDashType()→ inherited from Line
voidsetDashType(int value)
           Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.
intgetDisplayType()
voidsetDisplayType(int value)
           Represents error bar display type. The value of the property is ErrorBarDisplayType integer constant.
intgetEndArrowLength()→ inherited from Line
voidsetEndArrowLength(int value)
           Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.
intgetEndArrowWidth()→ inherited from Line
voidsetEndArrowWidth(int value)
           Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.
intgetEndType()→ inherited from Line
voidsetEndType(int value)
           Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.
intgetFormattingType()→ inherited from Line
voidsetFormattingType(int value)
           Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.
GradientFillgetGradientFill()→ inherited from Line
           Represents gradient fill.
booleanisAuto()→ inherited from Line
voidsetAuto(boolean value)
           Indicates whether this line style is auto assigned.
booleanisAutomaticColor()→ inherited from Line
           Indicates whether the color of line is auotmatic assigned.
booleanisVisible()→ inherited from Line
voidsetVisible(boolean value)
           Represents whether the line is visible.
intgetJoinType()→ inherited from Line
voidsetJoinType(int value)
           Specifies the joining caps. The value of the property is LineJoinType integer constant.
java.lang.StringgetMinusValue()
voidsetMinusValue(java.lang.String value)
           Represents negative error amount when error bar type is InnerCustom.
java.lang.StringgetPlusValue()
voidsetPlusValue(java.lang.String value)
           Represents positive error amount when error bar type is InnerCustom.
booleangetShowMarkerTTop()
voidsetShowMarkerTTop(boolean value)
           Indicates if formatting error bars with a T-top.
intgetStyle()→ inherited from Line
voidsetStyle(int value)
           Represents the style of the line. The value of the property is LineType integer constant.
doublegetTransparency()→ inherited from Line
voidsetTransparency(double value)
           Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
intgetType()
voidsetType(int value)
           Represents error bar amount type. The value of the property is ErrorBarType integer constant.
intgetWeight()→ inherited from Line
voidsetWeight(int value)
           Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.
doublegetWeightPt()→ inherited from Line
voidsetWeightPt(double value)
           Gets or sets the weight of the line in unit of points.
doublegetWeightPx()→ inherited from Line
voidsetWeightPx(double value)
           Gets or sets the weight of the line in uni of pixels.
 

Property Getters/Setters Detail

getType/setType

public int getType() / public void setType(int value)
Represents error bar amount type. The value of the property is ErrorBarType integer constant.

Example:

//Sets custom error bar type
aseries.getXErrorBar().setType(ErrorBarType.CUSTOM);
aseries.getXErrorBar().setPlusValue("=Sheet1!A1");
aseries.getXErrorBar().setMinusValue("=Sheet1!A2");

getDisplayType/setDisplayType

public int getDisplayType() / public void setDisplayType(int value)
Represents error bar display type. The value of the property is ErrorBarDisplayType integer constant.

getAmount/setAmount

public double getAmount() / public void setAmount(double value)
Represents amount of error bar. The amount must be greater than and equal to zero.

getShowMarkerTTop/setShowMarkerTTop

public boolean getShowMarkerTTop() / public void setShowMarkerTTop(boolean value)
Indicates if formatting error bars with a T-top.

getPlusValue/setPlusValue

public java.lang.String getPlusValue() / public void setPlusValue(java.lang.String value)
Represents positive error amount when error bar type is InnerCustom.

getMinusValue/setMinusValue

public java.lang.String getMinusValue() / public void setMinusValue(java.lang.String value)
Represents negative error amount when error bar type is InnerCustom.

getCompoundType/setCompoundType

→ inherited from Line
public int getCompoundType() / public void setCompoundType(int value)
Specifies the compound line type The value of the property is MsoLineStyle integer constant.

getDashType/setDashType

→ inherited from Line
public int getDashType() / public void setDashType(int value)
Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.

getCapType/setCapType

→ inherited from Line
public int getCapType() / public void setCapType(int value)
Specifies the ending caps. The value of the property is LineCapType integer constant.

getJoinType/setJoinType

→ inherited from Line
public int getJoinType() / public void setJoinType(int value)
Specifies the joining caps. The value of the property is LineJoinType integer constant.

getBeginType/setBeginType

→ inherited from Line
public int getBeginType() / public void setBeginType(int value)
Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.

getEndType/setEndType

→ inherited from Line
public int getEndType() / public void setEndType(int value)
Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.

getBeginArrowLength/setBeginArrowLength

→ inherited from Line
public int getBeginArrowLength() / public void setBeginArrowLength(int value)
Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.

getEndArrowLength/setEndArrowLength

→ inherited from Line
public int getEndArrowLength() / public void setEndArrowLength(int value)
Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.

getBeginArrowWidth/setBeginArrowWidth

→ inherited from Line
public int getBeginArrowWidth() / public void setBeginArrowWidth(int value)
Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.

getEndArrowWidth/setEndArrowWidth

→ inherited from Line
public int getEndArrowWidth() / public void setEndArrowWidth(int value)
Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.

getColor/setColor

→ inherited from Line
public Color getColor() / public void setColor(Color value)
Represents the com.aspose.cells.Color of the line.

getTransparency/setTransparency

→ inherited from Line
public double getTransparency() / public void setTransparency(double value)
Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).

getStyle/setStyle

→ inherited from Line
public int getStyle() / public void setStyle(int value)
Represents the style of the line. The value of the property is LineType integer constant.

getWeight/setWeight

→ inherited from Line
public int getWeight() / public void setWeight(int value)
Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.

getWeightPt/setWeightPt

→ inherited from Line
public double getWeightPt() / public void setWeightPt(double value)
Gets or sets the weight of the line in unit of points.

getWeightPx/setWeightPx

→ inherited from Line
public double getWeightPx() / public void setWeightPx(double value)
Gets or sets the weight of the line in uni of pixels.

getFormattingType/setFormattingType

→ inherited from Line
public int getFormattingType() / public void setFormattingType(int value)
Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.

isAutomaticColor

→ inherited from Line
public boolean isAutomaticColor()
Indicates whether the color of line is auotmatic assigned.

isVisible/setVisible

→ inherited from Line
public boolean isVisible() / public void setVisible(boolean value)
Represents whether the line is visible.

isAuto/setAuto

→ inherited from Line
public boolean isAuto() / public void setAuto(boolean value)
Indicates whether this line style is auto assigned.

getGradientFill

→ inherited from Line
public GradientFill getGradientFill()
Represents gradient fill.

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