Click or drag to resize

IChartDataPoint Interface

Represents data point in the chart.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public interface IChartDataPoint : IExcelApplication

The IChartDataPoint type exposes the following members.

Properties
Name Description
Public property Code example DataFormat
Gets / sets data format.
Examples
The following code illustrates how to access DataFormat and set ChartMarkerType.star to IChartSerieDataFormat.MarkerStyle:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Line;</para><para>//Set serie format</para><para>IChartSerieDataFormat format = chart.Series[0].DataFormat;</para><para>//Set marker style</para><para>format.MarkerStyle = ChartMarkerType.Star;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example DataLabels
Returns data labels object for the data point. Read-only.
Examples
The following code illustrates how to access the IChartDataLabels for a particular IChartDataPoint:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Get the chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Set data labels value visibility</para><para>serie.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example Index
Gets index of the point in the points collection.
Examples
The following code illustrates how to access the Index of a IChartDataPoint in the IChartDataPoints collection:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get index</para><para>Console.WriteLine(serie.DataPoints[0].Index);</para>
Public property Code example IsDefault
Indicates whether this data point is default data point. Read-only.
Examples
The following code illustrates how to access the IChartDataLabels for a particular IChartDataPoint:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set serie format</para><para>IChartDataPoints dataPoints = chart.Series[0].DataPoints;</para><para>//Check default Datapoint</para><para>Console.WriteLine(dataPoints.DefaultDataPoint.IsDefault);</para><para>Console.WriteLine(dataPoints[0].IsDefault);</para>
Public property Parent
Gets the parent object of the current instance.
(Inherited from IExcelApplication .)
Top
See Also