ErrorBar
Source: aspose.
Represents error bar of data series.
Methods
Methods
getAmount()
Represents amount of error bar. The amount must be greater than or equal to zero.
getBeginArrowLength()
Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.
getBeginArrowWidth()
Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.
getBeginType()
Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.
getCapType()
Specifies the ending caps. The value of the property is LineCapType integer constant.
getColor()
Represents the com.aspose.cells.Color of the line.
getCompoundType()
Specifies the compound line type The value of the property is MsoLineStyle integer constant.
getDashType()
Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.
getDisplayType()
Represents the display type of error bar. The value of the property is ErrorBarDisplayType integer constant.
getEndArrowLength()
Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.
getEndArrowWidth()
Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.
getEndType()
Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.
getFormattingType()
Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.
getGradientFill()
Represents gradient fill.
getJoinType()
Specifies the joining caps. The value of the property is LineJoinType integer constant.
getMinusValue()
Represents negative error amount when error bar type is Custom.
getPlusValue()
Represents positive error amount when error bar type is Custom.
getShowMarkerTTop()
Indicates if formatting error bars with a T-top.
getStyle()
Represents the style of the line. The value of the property is LineType integer constant.
getThemeColor()
Gets and sets the theme color. If the foreground color is not a theme color, NULL will be returned.
getTransparency()
Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
getType()
Represents error bar amount type. The value of the property is ErrorBarType integer constant.
Example
var workbook = new aspose.cells.Workbook();
var 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");
var chartIndex = workbook.getWorksheets().get(0).getCharts().add(aspose.cells.ChartType.COLUMN, 11, 0, 27, 10);
var chart = workbook.getWorksheets().get(0).getCharts().get(chartIndex);
chart.getNSeries().add("A1:B4", true);
chart.getNSeries().setCategoryData("C1:C4");
for (var i = 0; i < chart.getNSeries().getCount(); i++)
{
var aseries = chart.getNSeries().get(i);
//Sets custom error bar type
aseries.getXErrorBar().setType(aspose.cells.ErrorBarType.CUSTOM);
aseries.getXErrorBar().setPlusValue("=Sheet1!A1");
aseries.getXErrorBar().setMinusValue("=Sheet1!A2");
}getWeight()
Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.
getWeightPt()
Gets or sets the weight of the line in unit of points.
getWeightPx()
Gets or sets the weight of the line in unit of pixels.
isAuto()
Indicates whether this line style is auto assigned.
isAutomaticColor()
Indicates whether the color of line is automatic assigned.
isVisible()
Represents whether the line is visible.
setAmount()
Represents amount of error bar. The amount must be greater than or equal to zero.
setAuto()
Indicates whether this line style is auto assigned.
setBeginArrowLength()
Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.
setBeginArrowWidth()
Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.
setBeginType()
Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.
setCapType()
Specifies the ending caps. The value of the property is LineCapType integer constant.
setColor()
Represents the com.aspose.cells.Color of the line.
setCompoundType()
Specifies the compound line type The value of the property is MsoLineStyle integer constant.
setDashType()
Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.
setDisplayType()
Represents the display type of error bar. The value of the property is ErrorBarDisplayType integer constant.
setEndArrowLength()
Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.
setEndArrowWidth()
Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.
setEndType()
Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.
setFormattingType()
Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.
setJoinType()
Specifies the joining caps. The value of the property is LineJoinType integer constant.
setMinusValue()
Represents negative error amount when error bar type is Custom.
setPlusValue()
Represents positive error amount when error bar type is Custom.
setShowMarkerTTop()
Indicates if formatting error bars with a T-top.
setStyle()
Represents the style of the line. The value of the property is LineType integer constant.
setThemeColor()
Gets and sets the theme color. If the foreground color is not a theme color, NULL will be returned.
setTransparency()
Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).
setType()
Represents error bar amount type. The value of the property is ErrorBarType integer constant.
Example
var workbook = new aspose.cells.Workbook();
var 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");
var chartIndex = workbook.getWorksheets().get(0).getCharts().add(aspose.cells.ChartType.COLUMN, 11, 0, 27, 10);
var chart = workbook.getWorksheets().get(0).getCharts().get(chartIndex);
chart.getNSeries().add("A1:B4", true);
chart.getNSeries().setCategoryData("C1:C4");
for (var i = 0; i < chart.getNSeries().getCount(); i++)
{
var aseries = chart.getNSeries().get(i);
//Sets custom error bar type
aseries.getXErrorBar().setType(aspose.cells.ErrorBarType.CUSTOM);
aseries.getXErrorBar().setPlusValue("=Sheet1!A1");
aseries.getXErrorBar().setMinusValue("=Sheet1!A2");
}setVisible()
Represents whether the line is visible.
setWeight()
Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.
setWeightPt()
Gets or sets the weight of the line in unit of points.
setWeightPx()
Gets or sets the weight of the line in unit of pixels.