## ChartPoint class Represents a single point in a series in a chart. ```csharp public class ChartPoint ``` ## Properties | Name | Description | | --- | --- | | [ArcEndPointXPx](../../aspose.cells.charts/chartpoint/arcendpointxpx/) { get; } | Gets the x coordinate of the ending point for the pie section after calling the Chart.Calculate() method. Applies to Pie and Doughnut charts. | | [ArcEndPointYPx](../../aspose.cells.charts/chartpoint/arcendpointypx/) { get; } | Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart. | | [ArcStartPointXPx](../../aspose.cells.charts/chartpoint/arcstartpointxpx/) { get; } | Gets the x coordinate of the starting point for the pie section after calling the Chart.Calculate() method. Applies to Pie and Doughnut charts. | | [ArcStartPointYPx](../../aspose.cells.charts/chartpoint/arcstartpointypx/) { get; } | Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart. | | [Area](../../aspose.cells.charts/chartpoint/area/) { get; } | Gets the [` area`](./area/). | | [Border](../../aspose.cells.charts/chartpoint/border/) { get; } | Gets the [` border`](../../aspose.cells.drawing/line/). | | [BorderWidthPx](../../aspose.cells.charts/chartpoint/borderwidthpx/) { get; } | Gets the width of border in units of pixels after calling the Chart.Calculate() method. | | [DataLabels](../../aspose.cells.charts/chartpoint/datalabels/) { get; } | Returns a [`DataLabels`](./datalabels/) object that represents the data label associated with this chart point. | | [DoughnutInnerRadius](../../aspose.cells.charts/chartpoint/doughnutinnerradius/) { get; } | Gets the inner radius of doughnut slice in units of pixels after calling the Chart.Calculate() method. Applies to Doughnut chart. | | [EndAngle](../../aspose.cells.charts/chartpoint/endangle/) { get; } | 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. | | [Explosion](../../aspose.cells.charts/chartpoint/explosion/) { get; set; } | The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter. | | [InnerArcEndPointXPx](../../aspose.cells.charts/chartpoint/innerarcendpointxpx/) { get; } | Gets the x coordinate of the ending point for the pie section after calling the Chart.Calculate() method. Applies to Doughnut charts. | | [InnerArcEndPointYPx](../../aspose.cells.charts/chartpoint/innerarcendpointypx/) { get; } | Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart. | | [InnerArcStartPointXPx](../../aspose.cells.charts/chartpoint/innerarcstartpointxpx/) { get; } | Gets the x coordinate of the starting point for the pie section after calling the Chart.Calculate() method. Applies to the Doughnut chart. | | [InnerArcStartPointYPx](../../aspose.cells.charts/chartpoint/innerarcstartpointypx/) { get; } | Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart. | | [InnerRadiusPx](../../aspose.cells.charts/chartpoint/innerradiuspx/) { get; } | (**Obsolete.**) Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method. Applies to Doughnut chart. | | [IsInSecondaryPlot](../../aspose.cells.charts/chartpoint/isinsecondaryplot/) { get; set; } | Gets or 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 | | [Marker](../../aspose.cells.charts/chartpoint/marker/) { get; } | Gets the [` marker`](./marker/). | | [RadiusPx](../../aspose.cells.charts/chartpoint/radiuspx/) { get; } | Gets the radius of bubble, pie or doughnut in units of pixels after calls Chart.Calculate() method. | | [Shadow](../../aspose.cells.charts/chartpoint/shadow/) { get; set; } | True if the chartpoint has a shadow. | | [ShapeHeight](../../aspose.cells.charts/chartpoint/shapeheight/) { get; } | Gets the height in units of 1/4000 of chart's height after calls Chart.Calculate() method. | | [ShapeHeightPx](../../aspose.cells.charts/chartpoint/shapeheightpx/) { get; } | Gets the height in units of pixels after calls Chart.Calculate() method. | | [ShapeProperties](../../aspose.cells.charts/chartpoint/shapeproperties/) { get; } | Gets the [`ShapePropertyCollection`](../../aspose.cells.drawing/shapepropertycollection/) object that holds the visual shape properties of the ChartPoint. | | [ShapeWidth](../../aspose.cells.charts/chartpoint/shapewidth/) { get; } | Gets the width in units of 1/4000 of the chart's width after calling the Chart.Calculate() method. | | [ShapeWidthPx](../../aspose.cells.charts/chartpoint/shapewidthpx/) { get; } | Gets the width in units of pixels after calling the Chart.Calculate() method. | | [ShapeX](../../aspose.cells.charts/chartpoint/shapex/) { get; } | Gets the x coordinate of the upper left corner in units of 1/4000 of chart's width after calling the Chart.Calculate() method. | | [ShapeXPx](../../aspose.cells.charts/chartpoint/shapexpx/) { get; } | Gets the x coordinate of the upper left corner in units of pixels after calling the Chart.Calculate() method. | | [ShapeY](../../aspose.cells.charts/chartpoint/shapey/) { get; } | Gets the y coordinate of the upper left corner in units of 1/4000 of chart's height after calls Chart.Calculate() method. | | [ShapeYPx](../../aspose.cells.charts/chartpoint/shapeypx/) { get; } | Gets the y coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method. | | [StartAngle](../../aspose.cells.charts/chartpoint/startangle/) { get; } | Gets the starting angle for the pie section, measured in degrees clockwise from the x-axis after calling the Chart.Calculate() method. Applies to Pie chart. | | [XValue](../../aspose.cells.charts/chartpoint/xvalue/) { get; set; } | Gets or sets the X value of the chart point. | | [XValueType](../../aspose.cells.charts/chartpoint/xvaluetype/) { get; } | Gets X value type of the chart point. | | [YValue](../../aspose.cells.charts/chartpoint/yvalue/) { get; set; } | Gets or sets the Y value of the chart point. | | [YValueType](../../aspose.cells.charts/chartpoint/yvaluetype/) { get; } | Gets Y value type of the chart point. | ## Methods | Name | Description | | --- | --- | | [GetBottomPointCount](../../aspose.cells.charts/chartpoint/getbottompointcount/)() | Gets the number of bottom points after calls Chart.Calculate() method. | | [GetBottomPointXPx](../../aspose.cells.charts/chartpoint/getbottompointxpx/)(int) | Gets x-coordinate of the bottom point of the shape after calling the Chart.Calculate() method. Applies to 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid | | [GetBottomPointYPx](../../aspose.cells.charts/chartpoint/getbottompointypx/)(int) | Gets y-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid | | [GetOnCategoryAxisPointCount](../../aspose.cells.charts/chartpoint/getoncategoryaxispointcount/)() | Gets the number of the points on the category axis after calling the Chart.Calculate() method. Only applies to area charts. | | [GetOnCategoryAxisPointXPx](../../aspose.cells.charts/chartpoint/getoncategoryaxispointxpx/)(int) | Gets x-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Area chart. | | [GetOnCategoryAxisPointYPx](../../aspose.cells.charts/chartpoint/getoncategoryaxispointypx/)(int) | Gets y-coordinate of the point on category axis after calling the Chart.Calculate() method. Only applies to Area chart. | | [GetTopPointCount](../../aspose.cells.charts/chartpoint/gettoppointcount/)() | Gets the number of top points after calling the Chart.Calculate() method. | | [GetTopPointXPx](../../aspose.cells.charts/chartpoint/gettoppointxpx/)(int) | 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](../../aspose.cells.charts/chartpoint/gettoppointypx/)(int) | Gets y-coordinate of the top point of the shape after calling the Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid, and Area3D. | ### Examples ```csharp namespace AsposeCellsExamples { using Aspose.Cells; using Aspose.Cells.Charts; using System; using System.Drawing; public class ChartPointDemo { public static void ChartPointExample() { // Instantiating a Workbook object Workbook workbook = new Workbook(); // Obtaining the reference of the first worksheet Worksheet worksheet = workbook.Worksheets[0]; // Adding sample values to cells worksheet.Cells["A1"].PutValue(50); worksheet.Cells["A2"].PutValue(100); worksheet.Cells["A3"].PutValue(150); worksheet.Cells["B1"].PutValue(60); worksheet.Cells["B2"].PutValue(32); worksheet.Cells["B3"].PutValue(50); // Adding a chart to the worksheet int chartIndex = worksheet.Charts.Add(ChartType.PieExploded, 5, 0, 25, 10); // Accessing the instance of the newly added chart Chart chart = worksheet.Charts[chartIndex]; // Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3" chart.NSeries.Add("A1:B3", true); // Show Data Labels chart.NSeries[0].DataLabels.ShowValue = true; // Iterate through each point in the series for (int i = 0; i < chart.NSeries[0].Points.Count; i++) { // Get Data Point ChartPoint point = chart.NSeries[0].Points[i]; // Set Pie Explosion point.Explosion = 15; // Set Border Color point.Border.Color = Color.Red; // Set Shadow point.Shadow = true; // Set YValue point.YValue = 100 + i * 10; // Set XValue point.XValue = "Category " + (i + 1); // Set IsInSecondaryPlot point.IsInSecondaryPlot = false; } // Saving the Excel file workbook.Save("ChartPointExample.xlsx"); workbook.Save("ChartPointExample.pdf"); } } } ``` ### See Also * namespace [Aspose.Cells.Charts](../../aspose.cells.charts/) * assembly [Aspose.Cells](../../)