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);
$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);
//Applying a dotted line style on the lines of an NSeries
$series = $chart->getNSeries()->get(0);
$series->getBorder()->setColor(cells\Color::getRed());
$series->getBorder()->setStyle(cells\LineType::DOT);
//Applying a triangular marker style on the data markers of an NSeries
$series->getMarker()->setMarkerStyle(cells\ChartMarkerType::TRIANGLE);
$series = $chart->getNSeries()->get(1);
//Setting the weight of all lines in an NSeries to medium
$series->getBorder()->setWeight(cells\WeightType::MEDIUM_LINE);
$series->getBorder()->setColor(cells\Color::getGreen());
| Property Getters/Setters Summary | ||
|---|---|---|
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 | 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 automatic 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 | 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 | 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 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()