aspose.cells
Class SeriesCollection

//Instantiating a Workbook object
$workbook = new cells\Workbook();
//Adding a new worksheet to the Excel object
$sheetIndex = $workbook->getWorksheets()->add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
$worksheet = $workbook->getWorksheets()->get($sheetIndex);
$cells = $worksheet->getCells();
$cells->get("A1")->putValue(50);
$cells->get("A2")->putValue(100);
$cells->get("A3")->putValue(150);
$cells->get("A4")->putValue(200);
$cells->get("B1")->putValue(60);
$cells->get("B2")->putValue(32);
$cells->get("B3")->putValue(50);
$cells->get("B4")->putValue(40);
$cells->get("C1")->putValue("Q1");
$cells->get("C2")->putValue("Q2");
$cells->get("C3")->putValue("Y1");
$cells->get("C4")->putValue("Y2");
//Adding a chart to the worksheet
$chartIndex = $worksheet->getCharts()->add(cells\ChartType::COLUMN, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
$chart = $worksheet->getCharts()->get($chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4"
$chart->getNSeries()->add("A1:B4", true);
//Setting the data source for the category data of NSeries
$chart->getNSeries()->setCategoryData("C1:C4");

function getCategoryData() / function setCategoryData(value)

Gets or sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}").

function getSecondCatergoryData() / function setSecondCatergoryData(value)

Gets or sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis.

NOTE: This member is now obsolete. Instead, please use SeriesCollection.SecondCategoryData property. This property will be removed 12 months later since February 2014. Aspose apologizes for any inconvenience you may have experienced.

function getSecondCategoryData() / function setSecondCategoryData(value)

Gets or sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis.

function isColorVaried() / function setColorVaried(value)

Represents if the color of points is varied.

function getCount()

function get(index)

Gets the Series element at the specified index.

Parameters:

index - The zero based index of the element.

Returns:

The element at the specified index.

function getSeriesByOrder(order)

Gets the Series element by order.

Parameters:

order: Number - The order of series

Returns:

The element series

function removeAt(index)

Remove at a series at the specific index.

Parameters:

index: Number - The index.

function changeSeriesOrder(sourceIndex, destIndex)

Directly chanages the orders of the two series.

Parameters:

sourceIndex: Number - The current index

destIndex: Number - The dest index

function addR1C1(area, isVertical)

Adds the SeriesCollection collection to a chart.

If set data on contiguous cells, use colon to seperate them.For example, R[1]C[1]:R[3]C[2].

If set data on contiguous cells, use comma to seperate them.For example,(R[1]C[1],R[3]C[2]).

Parameters:

area: String - Specifies values from which to plot the data series

isVertical: boolean - Specifies whether to plot the series from a range of cell values by row or by column.

Returns:

Return the first index of the added ASeries in the NSeries.

function add(area, isVertical)

Adds the SeriesCollection collection to a chart.

If set data on contiguous cells, use colon to seperate them.For example, $C$2:$C$5.

If set data on non contiguous cells, use comma to seperate them.For example: ($C$2,$D$5).

Parameters:

area: String - Specifies values from which to plot the data series

isVertical: boolean - Specifies whether to plot the series from a range of cell values by row or by column.

Returns:

Return the first index of the added ASeries in the NSeries.

function clear()

Clears the collection

function iterator()

function get(index)

Reserved for internal use.

function contains(value)

Reserved for internal use.

function add(value)

Reserved for internal use.

function indexOf(value)

Reserved for internal use.