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