aspose.cells
Class ErrorBar

$workbook = new cells\Workbook();
$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");
 
$chartIndex = $workbook->getWorksheets()->get(0)->getCharts()->add(cells\ChartType::COLUMN, 11, 0, 27, 10);
 
$chart = $workbook->getWorksheets()->get(0)->getCharts()->get($chartIndex);
$chart->getNSeries()->add("A1:B4", true);
 
$chart->getNSeries()->setCategoryData("C1:C4");

for ($i = 0; $i < $chart->getNSeries()->getCount(); $i++)
{
    $aseries = $chart->getNSeries()->get($i);
    $aseries->getYErrorBar()->setDisplayType(cells\ErrorBarDisplayType::MINUS);
    $aseries->getYErrorBar()->setType(cells\ErrorBarType::FIXED_VALUE);
    $aseries->getYErrorBar()->setAmount(5);
}

function getType() / function setType(value)

Represents error bar amount type. The value of the property is ErrorBarType integer constant.

Example:

$workbook = new cells\Workbook();
$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");
 
$chartIndex = $workbook->getWorksheets()->get(0)->getCharts()->add(cells\ChartType::COLUMN, 11, 0, 27, 10);
$chart = $workbook->getWorksheets()->get(0)->getCharts()->get($chartIndex);
$chart->getNSeries()->add("A1:B4", true);

$chart->getNSeries()->setCategoryData("C1:C4");

$count = (int)"".$chart->getNSeries()->getCount();
for ($i = 0; $i < $count; $i++)
{
    $aseries = $chart->getNSeries()->get($i);
    //Sets custom error bar type
    $aseries->getYErrorBar()->setDisplayType(cells\ErrorBarDisplayType::MINUS);
    $aseries->getYErrorBar()->setType(cells\ErrorBarType::CUSTOM);
    $aseries->getYErrorBar()->setPlusValue("=Sheet1!A1");
    $aseries->getYErrorBar()->setMinusValue("=Sheet1!A2");
}

function getDisplayType() / function setDisplayType(value)

Represents error bar display type. The value of the property is ErrorBarDisplayType integer constant.

function getAmount() / function setAmount(value)

Represents amount of error bar. The amount must be greater than and equal to zero.

function getShowMarkerTTop() / function setShowMarkerTTop(value)

Indicates if formatting error bars with a T-top.

function getPlusValue() / function setPlusValue(value)

Represents positive error amount when error bar type is InnerCustom.

function getMinusValue() / function setMinusValue(value)

Represents negative error amount when error bar type is InnerCustom.

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 getCapType() / function setCapType(value)

Specifies the ending caps. The value of the property is LineCapType integer constant.

function getJoinType() / function setJoinType(value)

Specifies the joining caps. The value of the property is LineJoinType 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 getEndType() / function setEndType(value)

Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.

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 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 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 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 getThemeColor() / function setThemeColor(value)

Gets and sets the theme color.

If the forground color is not a theme color, NULL will be returned.

function getColor() / function setColor(value)

Represents the com.aspose.cells.Color of the line.

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 getStyle() / function setStyle(value)

Represents the style of the line. The value of the property is LineType integer constant.

function getWeight() / function setWeight(value)

Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.

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 uni of pixels.

function getFormattingType() / function setFormattingType(value)

Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.

function isAutomaticColor()

Indicates whether the color of line is auotmatic assigned.

function isVisible() / function setVisible(value)

Represents whether the line is visible.

function isAuto() / function setAuto(value)

Indicates whether this line style is auto assigned.

function getGradientFill()

Represents gradient fill.