Aspose::Cells::Charts::ChartPointCollection class

ChartPointCollection class

Represents a collection that contains all the points in one series.

class ChartPointCollection

Methods

Method	Description
ChartPointCollection(ChartPointCollection_Impl* impl)	Constructs from an implementation object.
ChartPointCollection(const ChartPointCollection& src)	Copy constructor.
Clear()	Remove all setting of the chart points.
Get(int32_t index)	Gets the ChartPoint element at the specified index in the series.
GetCount()	Gets the count of the chart point.
GetEnumerator()	Returns an enumerator for the entire ChartPointCollection.
IsNull() const	Checks whether the implementation object is nullptr.
explicit operator bool() const	operator bool()
operator=(const ChartPointCollection& src)	operator=
RemoveAt(int32_t index)	Removes point at the index of the series..
~ChartPointCollection()	Destructor.

Fields

Field	Description
_impl	The implementation object.

Examples

Aspose::Cells::Startup();
//Instantiating a Workbook object
Workbook workbook;

//Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.GetWorksheets().Get(0);

//Adding a sample value to "A1" cell
worksheet.GetCells().Get(u"A1").PutValue(50);

//Adding a sample value to "A2" cell
worksheet.GetCells().Get(u"A2").PutValue(100);

//Adding a sample value to "A3" cell
worksheet.GetCells().Get(u"A3").PutValue(150);

//Adding a sample value to "B1" cell
worksheet.GetCells().Get(u"B1").PutValue(60);

//Adding a sample value to "B2" cell
worksheet.GetCells().Get(u"B2").PutValue(32);

//Adding a sample value to "B3" cell
worksheet.GetCells().Get(u"B3").PutValue(50);

//Adding a chart to the worksheet
int chartIndex = worksheet.GetCharts().Add(ChartType::PieExploded, 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(u"A1:B3", true);

//Show Data Labels
chart.GetNSeries().Get(0).GetDataLabels().SetShowValue(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(Color{ 0xff, 0xff, 0, 0 });
}

//Saving the Excel file
workbook.Save(u"book1.xls");

Aspose::Cells::Cleanup();

See Also

• Namespace Aspose::Cells::Charts
• Library Aspose.Cells for C++