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); aseries.getXErrorBar().setDisplayType(aspose.cells.ErrorBarDisplayType.MINUS); aseries.getXErrorBar().setType(aspose.cells.ErrorBarType.FIXED_VALUE); aseries.getXErrorBar().setAmount(5); }
Property Getters/Setters Summary | ||
---|---|---|
function | getAmount() | |
function | setAmount(value) | |
Represents amount of error bar.
|
||
function | getBeginArrowLength() | |
function | setBeginArrowLength(value) | |
Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant. | ||
function | getBeginArrowWidth() | |
function | setBeginArrowWidth(value) | |
Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant. | ||
function | getBeginType() | |
function | setBeginType(value) | |
Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant. | ||
function | getCapType() | |
function | setCapType(value) | |
Specifies the ending caps. The value of the property is LineCapType integer constant. | ||
function | getColor() | |
function | setColor(value) | |
Represents the |
||
function | getCompoundType() | |
function | setCompoundType(value) | |
Specifies the compound line type The value of the property is MsoLineStyle integer constant. | ||
function | getDashType() | |
function | setDashType(value) | |
Specifies the dash line type The value of the property is MsoLineDashStyle integer constant. | ||
function | getDisplayType() | |
function | setDisplayType(value) | |
Represents error bar display type. The value of the property is ErrorBarDisplayType integer constant. | ||
function | getEndArrowLength() | |
function | setEndArrowLength(value) | |
Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant. | ||
function | getEndArrowWidth() | |
function | setEndArrowWidth(value) | |
Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant. | ||
function | getEndType() | |
function | setEndType(value) | |
Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant. | ||
function | getFormattingType() | |
function | setFormattingType(value) | |
Gets or sets format type. The value of the property is ChartLineFormattingType integer constant. | ||
function | getGradientFill() | |
Represents gradient fill.
|
||
function | isAuto() | |
function | setAuto(value) | |
Indicates whether this line style is auto assigned. | ||
function | isAutomaticColor() | |
Indicates whether the color of line is auotmatic assigned.
|
||
function | isVisible() | |
function | setVisible(value) | |
Represents whether the line is visible. | ||
function | getJoinType() | |
function | setJoinType(value) | |
Specifies the joining caps. The value of the property is LineJoinType integer constant. | ||
function | getMinusValue() | |
function | setMinusValue(value) | |
Represents negative error amount when error bar type is Custom. | ||
function | getPlusValue() | |
function | setPlusValue(value) | |
Represents positive error amount when error bar type is Custom. | ||
function | getShowMarkerTTop() | |
function | setShowMarkerTTop(value) | |
Indicates if formatting error bars with a T-top. | ||
function | getStyle() | |
function | setStyle(value) | |
Represents the style of the line. The value of the property is LineType integer constant. | ||
function | getThemeColor() | |
function | setThemeColor(value) | |
Gets and sets the theme color. | ||
function | getTransparency() | |
function | setTransparency(value) | |
Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear). | ||
function | getType() | |
function | setType(value) | |
Represents error bar amount type. The value of the property is ErrorBarType integer constant. | ||
function | getWeight() | |
function | setWeight(value) | |
Gets or sets the |
||
function | getWeightPt() | |
function | setWeightPt(value) | |
Gets or sets the weight of the line in unit of points. | ||
function | getWeightPx() | |
function | setWeightPx(value) | |
Gets or sets the weight of the line in unit of pixels. |
function getType() / function setType(value)
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"); }
function getDisplayType() / function setDisplayType(value)
function getAmount() / function setAmount(value)
function getShowMarkerTTop() / function setShowMarkerTTop(value)
function getPlusValue() / function setPlusValue(value)
function getMinusValue() / function setMinusValue(value)
function getCompoundType() / function setCompoundType(value)
function getDashType() / function setDashType(value)
function getCapType() / function setCapType(value)
function getJoinType() / function setJoinType(value)
function getBeginType() / function setBeginType(value)
function getEndType() / function setEndType(value)
function getBeginArrowLength() / function setBeginArrowLength(value)
function getEndArrowLength() / function setEndArrowLength(value)
function getBeginArrowWidth() / function setBeginArrowWidth(value)
function getEndArrowWidth() / function setEndArrowWidth(value)
function getThemeColor() / function setThemeColor(value)
function getColor() / function setColor(value)
function getTransparency() / function setTransparency(value)
function getStyle() / function setStyle(value)
function getWeight() / function setWeight(value)
function getWeightPt() / function setWeightPt(value)
function getWeightPx() / function setWeightPx(value)
function getFormattingType() / function setFormattingType(value)
function isAutomaticColor()
function isVisible() / function setVisible(value)
function isAuto() / function setAuto(value)
function getGradientFill()