Aspose::Cells::Charts::IChartPoint Class Referenceabstract

Represents a single point in a series in a chart. More...

Inherits Object.

Public Member Functions

virtual Aspose::Cells::Systems::Int32 GetExplosion ()=0
 The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter. More...
 
virtual void SetExplosion (Aspose::Cells::Systems::Int32 value)=0
 The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter. More...
 
virtual bool GetShadow ()=0
 True if the chartpoint has a shadow. More...
 
virtual void SetShadow (bool value)=0
 True if the chartpoint has a shadow. More...
 
virtual intrusive_ptr< Aspose::Cells::Drawing::ILineGetBorderILine ()=0
 Gets the border More...
 
virtual intrusive_ptr< Aspose::Cells::Drawing::IAreaGetIArea ()=0
 Gets the area More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IMarkerGetIMarker ()=0
 Gets the marker More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IDataLabelsGetIDataLabels ()=0
 Returns a DataLabels object that represents the data label associated with the point. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Object > Get_YValue ()=0
 Gets or sets the Y value of the chart point. More...
 
virtual void SetYValue (intrusive_ptr< Aspose::Cells::Systems::Object > value)=0
 Gets the Y value of the chart point. More...
 
virtual Aspose::Cells::CellValueType GetYValueType ()=0
 Gets Y value type of the chart point. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Object > GetXValue ()=0
 Gets or sets the X value of the chart point. More...
 
virtual void SetXValue (intrusive_ptr< Aspose::Cells::Systems::Object > value)=0
 Gets or sets the X value of the chart point. More...
 
virtual Aspose::Cells::CellValueType GetXValueType ()=0
 Gets X value type of the chart point. More...
 
virtual intrusive_ptr< Aspose::Cells::Drawing::IShapePropertyCollectionGetIShapeProperties ()=0
 Gets the
See also
IShapePropertyCollection

object that holds the visual shape properties of the ChartPoint. More...

 
virtual bool IsInSecondaryPlot ()=0
 Gets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart More...
 
virtual void SetInSecondaryPlot (bool value)=0
 Sets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeX ()=0
 Gets the x coordinate of the upper left corner in units of 1/4000 of chart's width after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeY ()=0
 Gets the y coordinate of the upper left corner in units of 1/4000 of chart's height after calls Chart.Calculate() method.
More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeWidth ()=0
 Gets the width in units of 1/4000 of chart's width after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeHeight ()=0
 Gets the height in units of 1/4000 of chart's height after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeXPx ()=0
 Gets the x coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeYPx ()=0
 Gets the y coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeWidthPx ()=0
 Gets the width in units of pixels after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetShapeHeightPx ()=0
 Gets the height in units of pixels after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetBorderWidthPx ()=0
 Gets the width of border in units of pixels after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetRadiusPx ()=0
 Gets the radius of bubble, pie or doughnut in units of pixels after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Int32 GetInnerRadiusPx ()=0
 Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method. Applies to Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetStartAngle ()=0
 Gets the starting angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart. More...
 
virtual Aspose::Cells::Systems::Single GetEndAngle ()=0
 Gets the ending angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart. More...
 
virtual Aspose::Cells::Systems::Single GetArcStartPointXPx ()=0
 Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetArcStartPointYPx ()=0
 Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetArcEndPointXPx ()=0
 Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetArcEndPointYPx ()=0
 Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetInnerArcStartPointXPx ()=0
 Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetInnerArcStartPointYPx ()=0
 Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetInnerArcEndPointXPx ()=0
 Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Single GetInnerArcEndPointYPx ()=0
 Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart. More...
 
virtual Aspose::Cells::Systems::Int32 GetTopPointCount ()=0
 Gets the number of top points after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Single GetTopPointXPx (Aspose::Cells::Systems::Int32 index)=0
 Gets x-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D More...
 
virtual Aspose::Cells::Systems::Single GetTopPointYPx (Aspose::Cells::Systems::Int32 index)=0
 Gets y-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D More...
 
virtual Aspose::Cells::Systems::Int32 GetBottomPointCount ()=0
 Gets the number of bottom points after calls Chart.Calculate() method. More...
 
virtual Aspose::Cells::Systems::Single GetBottomPointXPx (Aspose::Cells::Systems::Int32 index)=0
 Gets x-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid More...
 
virtual Aspose::Cells::Systems::Single GetBottomPointYPx (Aspose::Cells::Systems::Int32 index)=0
 Gets y-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid More...
 
virtual Aspose::Cells::Systems::Int32 GetOnCategoryAxisPointCount ()=0
 Gets the number of the points on category axis after calls Calculate() method in Chart. Only applies to area chart. More...
 
virtual Aspose::Cells::Systems::Single GetOnCategoryAxisPointXPx (Aspose::Cells::Systems::Int32 index)=0
 Gets x-coordinate of the point on category axis after calls Calculate() method in Chart. Only applies to Aarea chart. More...
 
virtual Aspose::Cells::Systems::Single GetOnCategoryAxisPointYPx (Aspose::Cells::Systems::Int32 index)=0
 Gets y-coordinate of the point on category axis after calls Calculate() method in Chart. Only applies to Area chart. More...
 

Detailed Description

Represents a single point in a series in a chart.

[C++]
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook();
//Obtaining the reference of the first worksheet
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);
//Adding a sample value to "A1" cell
worksheet->GetICells()->GetObjectByIndex(new String("A1"))->PutValue(50);
//Adding a sample value to "A2" cell
worksheet->GetICells()->GetObjectByIndex(new String("A2"))->PutValue(100);
//Adding a sample value to "A3" cell
worksheet->GetICells()->GetObjectByIndex(new String("A3"))->PutValue(150);
//Adding a sample value to "B1" cell
worksheet->GetICells()->GetObjectByIndex(new String("B1"))->PutValue(60);
//Adding a sample value to "A2" cell
worksheet->GetICells()->GetObjectByIndex(new String("B2"))->PutValue(32);
//Adding a sample value to "A3" cell
worksheet->GetICells()->GetObjectByIndex(new String("B3"))->PutValue(50);
//Adding a chart to the worksheet
int chartIndex = worksheet->GetICharts()->Add(ChartType_Column, 5, 0, 25, 10);
//Accessing the instance of the newly added chart
intrusive_ptr<IChart> chart = worksheet->GetICharts()->GetObjectByIndex(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
chart->GetNISeries()->Add(new String("A1:B3"), true);
//Show Data Labels
chart->GetNISeries()->GetObjectByIndex(0)->GetIDataLabels()->SetValueShown(true);
for (int i = 0; i < chart->GetNISeries()->GetObjectByIndex(0)->GetIPoints()->GetCount(); i++)
{
//Get Data Point
intrusive_ptr<IChartPoint> point = chart->GetNISeries()->GetObjectByIndex(0)->GetIPoints()->GetObjectByIndex(i);
//Set Pir Explosion
point->SetExplosion (15);
//Set Border Color
point->GetBorderILine()->SetColor(Systems::Drawing::Color::GetRed());
}
//Saving the Excel file
workbook->Save(new String("D:\\test\\ChartPointTest.xls"));

Member Function Documentation

◆ Get_YValue()

virtual intrusive_ptr<Aspose::Cells::Systems::Object> Aspose::Cells::Charts::IChartPoint::Get_YValue ( )
pure virtual

Gets or sets the Y value of the chart point.

◆ GetArcEndPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetArcEndPointXPx ( )
pure virtual

Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.

◆ GetArcEndPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetArcEndPointYPx ( )
pure virtual

Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.

◆ GetArcStartPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetArcStartPointXPx ( )
pure virtual

Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.

◆ GetArcStartPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetArcStartPointYPx ( )
pure virtual

Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.

◆ GetBorderILine()

virtual intrusive_ptr<Aspose::Cells::Drawing::ILine> Aspose::Cells::Charts::IChartPoint::GetBorderILine ( )
pure virtual

Gets the border

◆ GetBorderWidthPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetBorderWidthPx ( )
pure virtual

Gets the width of border in units of pixels after calls Chart.Calculate() method.

◆ GetBottomPointCount()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetBottomPointCount ( )
pure virtual

Gets the number of bottom points after calls Chart.Calculate() method.

◆ GetBottomPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetBottomPointXPx ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets x-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid

◆ GetBottomPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetBottomPointYPx ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets y-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid

◆ GetEndAngle()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetEndAngle ( )
pure virtual

Gets the ending angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart.

◆ GetExplosion()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetExplosion ( )
pure virtual

The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.

◆ GetIArea()

virtual intrusive_ptr<Aspose::Cells::Drawing::IArea> Aspose::Cells::Charts::IChartPoint::GetIArea ( )
pure virtual

Gets the area

◆ GetIDataLabels()

virtual intrusive_ptr<Aspose::Cells::Charts::IDataLabels> Aspose::Cells::Charts::IChartPoint::GetIDataLabels ( )
pure virtual

Returns a DataLabels object that represents the data label associated with the point.

◆ GetIMarker()

virtual intrusive_ptr<Aspose::Cells::Charts::IMarker> Aspose::Cells::Charts::IChartPoint::GetIMarker ( )
pure virtual

Gets the marker

◆ GetInnerArcEndPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetInnerArcEndPointXPx ( )
pure virtual

Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.

◆ GetInnerArcEndPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetInnerArcEndPointYPx ( )
pure virtual

Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.

◆ GetInnerArcStartPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetInnerArcStartPointXPx ( )
pure virtual

Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.

◆ GetInnerArcStartPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetInnerArcStartPointYPx ( )
pure virtual

Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.

◆ GetInnerRadiusPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetInnerRadiusPx ( )
pure virtual

Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method. Applies to Doughnut chart.

◆ GetIShapeProperties()

virtual intrusive_ptr<Aspose::Cells::Drawing::IShapePropertyCollection> Aspose::Cells::Charts::IChartPoint::GetIShapeProperties ( )
pure virtual

Gets the

See also
IShapePropertyCollection

object that holds the visual shape properties of the ChartPoint.

◆ GetOnCategoryAxisPointCount()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetOnCategoryAxisPointCount ( )
pure virtual

Gets the number of the points on category axis after calls Calculate() method in Chart. Only applies to area chart.

Area 2D chart return 1 Area 3D chart return 2.

◆ GetOnCategoryAxisPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetOnCategoryAxisPointXPx ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets x-coordinate of the point on category axis after calls Calculate() method in Chart. Only applies to Aarea chart.

Area 2D chart: index is 0. Area 3D chart: index is 0 or 1.

◆ GetOnCategoryAxisPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetOnCategoryAxisPointYPx ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets y-coordinate of the point on category axis after calls Calculate() method in Chart. Only applies to Area chart.

Area 2D chart: index is 0. Area 3D chart: index is 0 or 1.

◆ GetRadiusPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetRadiusPx ( )
pure virtual

Gets the radius of bubble, pie or doughnut in units of pixels after calls Chart.Calculate() method.

◆ GetShadow()

virtual bool Aspose::Cells::Charts::IChartPoint::GetShadow ( )
pure virtual

True if the chartpoint has a shadow.

◆ GetShapeHeight()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeHeight ( )
pure virtual

Gets the height in units of 1/4000 of chart's height after calls Chart.Calculate() method.

◆ GetShapeHeightPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeHeightPx ( )
pure virtual

Gets the height in units of pixels after calls Chart.Calculate() method.

◆ GetShapeWidth()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeWidth ( )
pure virtual

Gets the width in units of 1/4000 of chart's width after calls Chart.Calculate() method.

◆ GetShapeWidthPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeWidthPx ( )
pure virtual

Gets the width in units of pixels after calls Chart.Calculate() method.

◆ GetShapeX()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeX ( )
pure virtual

Gets the x coordinate of the upper left corner in units of 1/4000 of chart's width after calls Chart.Calculate() method.

◆ GetShapeXPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeXPx ( )
pure virtual

Gets the x coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.

◆ GetShapeY()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeY ( )
pure virtual

Gets the y coordinate of the upper left corner in units of 1/4000 of chart's height after calls Chart.Calculate() method.

◆ GetShapeYPx()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetShapeYPx ( )
pure virtual

Gets the y coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.

◆ GetStartAngle()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetStartAngle ( )
pure virtual

Gets the starting angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart.

◆ GetTopPointCount()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChartPoint::GetTopPointCount ( )
pure virtual

Gets the number of top points after calls Chart.Calculate() method.

◆ GetTopPointXPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetTopPointXPx ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets x-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D

◆ GetTopPointYPx()

virtual Aspose::Cells::Systems::Single Aspose::Cells::Charts::IChartPoint::GetTopPointYPx ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets y-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D

◆ GetXValue()

virtual intrusive_ptr<Aspose::Cells::Systems::Object> Aspose::Cells::Charts::IChartPoint::GetXValue ( )
pure virtual

Gets or sets the X value of the chart point.

◆ GetXValueType()

virtual Aspose::Cells::CellValueType Aspose::Cells::Charts::IChartPoint::GetXValueType ( )
pure virtual

Gets X value type of the chart point.

◆ GetYValueType()

virtual Aspose::Cells::CellValueType Aspose::Cells::Charts::IChartPoint::GetYValueType ( )
pure virtual

Gets Y value type of the chart point.

◆ IsInSecondaryPlot()

virtual bool Aspose::Cells::Charts::IChartPoint::IsInSecondaryPlot ( )
pure virtual

Gets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart

◆ SetExplosion()

virtual void Aspose::Cells::Charts::IChartPoint::SetExplosion ( Aspose::Cells::Systems::Int32  value)
pure virtual

The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.

◆ SetInSecondaryPlot()

virtual void Aspose::Cells::Charts::IChartPoint::SetInSecondaryPlot ( bool  value)
pure virtual

Sets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart

◆ SetShadow()

virtual void Aspose::Cells::Charts::IChartPoint::SetShadow ( bool  value)
pure virtual

True if the chartpoint has a shadow.

◆ SetXValue()

virtual void Aspose::Cells::Charts::IChartPoint::SetXValue ( intrusive_ptr< Aspose::Cells::Systems::Object >  value)
pure virtual

Gets or sets the X value of the chart point.

◆ SetYValue()

virtual void Aspose::Cells::Charts::IChartPoint::SetYValue ( intrusive_ptr< Aspose::Cells::Systems::Object >  value)
pure virtual

Gets the Y value of the chart point.