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->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 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 | 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 uni of pixels. | ||
| Property Getters/Setters Detail |
|---|
getCompoundType/setCompoundType : Number | |
function getCompoundType() / function setCompoundType(value) | |
getDashType/setDashType : Number | |
function getDashType() / function setDashType(value) | |
getCapType/setCapType : Number | |
function getCapType() / function setCapType(value) | |
getJoinType/setJoinType : Number | |
function getJoinType() / function setJoinType(value) | |
getBeginType/setBeginType : Number | |
function getBeginType() / function setBeginType(value) | |
getEndType/setEndType : Number | |
function getEndType() / function setEndType(value) | |
getBeginArrowLength/setBeginArrowLength : Number | |
function getBeginArrowLength() / function setBeginArrowLength(value) | |
getEndArrowLength/setEndArrowLength : Number | |
function getEndArrowLength() / function setEndArrowLength(value) | |
getBeginArrowWidth/setBeginArrowWidth : Number | |
function getBeginArrowWidth() / function setBeginArrowWidth(value) | |
getEndArrowWidth/setEndArrowWidth : Number | |
function getEndArrowWidth() / function setEndArrowWidth(value) | |
getThemeColor/setThemeColor : ThemeColor | |
function getThemeColor() / function setThemeColor(value) | |
getColor/setColor : Color | |
function getColor() / function setColor(value) | |
getTransparency/setTransparency : Number | |
function getTransparency() / function setTransparency(value) | |
getStyle/setStyle : Number | |
function getStyle() / function setStyle(value) | |
getWeight/setWeight : Number | |
function getWeight() / function setWeight(value) | |
getWeightPt/setWeightPt : Number | |
function getWeightPt() / function setWeightPt(value) | |
getWeightPx/setWeightPx : Number | |
function getWeightPx() / function setWeightPx(value) | |
getFormattingType/setFormattingType : Number | |
function getFormattingType() / function setFormattingType(value) | |
isAutomaticColor : boolean | |
function isAutomaticColor() | |
isVisible/setVisible : boolean | |
function isVisible() / function setVisible(value) | |
isAuto/setAuto : boolean | |
function isAuto() / function setAuto(value) | |
getGradientFill : GradientFill | |
function getGradientFill() | |