GrapeCity.Documents.Excel.Drawing.IPoint

IPoint Interface

Represents a single point in a chart series.

An IPoint instance represents an individual data point within a series and provides access to point-specific settings such as formatting, marker options, data labels, explosion for pie or doughnut slices, and other point-level chart behavior.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface IPoint

Public Interface IPoint

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Item", "Sales"},
    {"North", 12},
    {"South", 18},
    {"West", 9}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 230);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
IPoint point = shape.Chart.SeriesCollection[0].Points[0];

Properties

Name	Description
DataLabel	Gets the data label associated with the point.
Explosion	Gets or sets the explosion value for a pie-chart or doughnut-chart slice. Returns `0` if there is no explosion and the tip of the slice is in the center of the pie.
Format	Gets the format of the point.
Has3DEffect	Gets or sets whether the point has a three-dimensional appearance. Use this property to determine whether an individual data point is displayed with a three-dimensional effect in a bubble chart.
HasDataLabel	Gets or sets whether the point has a data label. This property indicates whether a data label is displayed for the individual point in the chart series.
InvertIfNegative	Gets or sets whether Microsoft Excel inverts the pattern for this point when it corresponds to a negative number. When this property is `true`, the point uses the inverted pattern if its value is negative.
IsTotal	Gets or sets whether the point is a total data point. This property is valid only for points in a waterfall chart.
MarkerFormat	Gets the marker format for this point. Use the returned IChartFormat object to configure the fill and line formatting of the point marker.
MarkerSize	Gets or sets the data marker size in points. Use this property to retrieve the marker size applied to a chart point.
MarkerStyle	Gets or sets the marker style for a point or series in a line, scatter, or radar chart. Use this property to retrieve the current marker appearance applied to the point.
Parent	Gets the series that contains this point. Use this property to access the parent ISeries of a data point in a chart series.
PictureType	Gets or sets how pictures are displayed on a column or bar picture chart.
PictureUnit	Gets or sets the unit for each picture on the point. This property is used only when the picture type is set to StackScale. If the picture type is not `StackScale`, this property is ignored.
SecondaryPlot	Gets or sets whether the point is in the secondary section of a pie-of-pie or bar-of-pie chart. This property applies only to points in the pie or bar section of pie-of-pie and bar-of-pie charts.