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.
com.aspose.cells.ColorgetColor()→ inherited from Line
voidsetColor(com.aspose.cells.Color value)
           Represents the com.aspose.cells.Color of the line.
intgetDisplayType()
voidsetDisplayType(int value)
           Represents error bar display type. The value of the property is ErrorBarDisplayType 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.
java.lang.StringgetMinusValue()
voidsetMinusValue(java.lang.String value)
           Represents negative error amount when error bar type is Custom.
java.lang.StringgetPlusValue()
voidsetPlusValue(java.lang.String value)
           Represents positive error amount when error bar type is Custom.
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. Only applies for Excel 2007 file.
 

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 Custom.

getMinusValue/setMinusValue

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

getColor/setColor

→ inherited from Line
public com.aspose.cells.Color getColor() / public void setColor(com.aspose.cells.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. Only applies for Excel 2007 file.

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.