java.lang.Object
com.aspose.cells.ChartPointCollection
public class ChartPointCollection
- extends java.lang.Object
Represents a collection that contains all the points in one series.
Example:
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
//Adding a sample value to "A1" cell
worksheet.getCells().get("A1").putValue(50);
//Adding a sample value to "A2" cell
worksheet.getCells().get("A2").putValue(100);
//Adding a sample value to "A3" cell
worksheet.getCells().get("A3").putValue(150);
//Adding a sample value to "B1" cell
worksheet.getCells().get("B1").putValue(60);
//Adding a sample value to "B2" cell
worksheet.getCells().get("B2").putValue(32);
//Adding a sample value to "B3" cell
worksheet.getCells().get("B3").putValue(50);
//Adding a chart to the worksheet
int chartIndex = worksheet.getCharts().add(ChartType.PIE_EXPLODED, 5, 0, 25, 10);
//Accessing the instance of the newly added chart
Chart chart = worksheet.getCharts().get(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
chart.getNSeries().add("A1:B3", true);
//Show Data Labels
chart.getNSeries().get(0).getDataLabels().setValueShown(true);
ChartPointCollection points = chart.getNSeries().get(0).getPoints();
for (int i = 0; i < points.getCount(); i++)
{
//Get Data Point
ChartPoint point = points.get(i);
//Set Pir Explosion
point.setExplosion(15);
//Set Border Color
point.getBorder().setColor(com.aspose.cells.Color.getRed());
}
//Saving the Excel file
workbook.save("D:\\book1.xls");
Property Getters/Setters Summary |
int | getCount() | |
|
Gets the count of the chart point.
|
ChartPoint | get(int index) | |
|
Gets the ChartPoint element at the specified index in the series.
|
Method Summary |
void | clear() | |
Remove all setting of the chart points.
|
java.util.Iterator | iterator() | |
Returns an enumerator for the entire ChartPointCollection.
|
void | removeAt(int index) | |
Removes point at the index of the series..
|
Property Getters/Setters Detail |
getCount | |
public int getCount()
|
-
Gets the count of the chart point.
-
Gets the ChartPoint element at the specified index in the series.
- Parameters:
index
- The index of chart point in the series.
- Returns:
- The ChartPoint object.
iterator | |
public java.util.Iterator iterator() |
-
Returns an enumerator for the entire ChartPointCollection.
- Returns:
clear | |
public void clear() |
-
Remove all setting of the chart points.
removeAt | |
public void removeAt(int index) |
-
Removes point at the index of the series..
- Parameters:
index
- The index of the point.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.