java.lang.Object
Line
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 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.
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.
-
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.