com.aspose.cells

Class ChartPointCollection

  • 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
intgetCount()
Gets the count of the chart point.
ChartPointget(int index)
Gets the ChartPoint element at the specified index in the series.
 
Method Summary
voidclear()
Remove all setting of the chart points.
java.util.Iteratoriterator()
Returns an enumerator for the entire ChartPointCollection.
voidremoveAt(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.
      • get

        public ChartPoint get(int index)
        
        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.
    • Method Detail

      • 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.