EmptyValueStyle Enumeration

Specifies how to show empty worksheet cells in a data series in the chart.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum EmptyValueStyle 
   Inherits System.Enum

'Usage
 
Dim instance As EmptyValueStyle

public enum EmptyValueStyle : System.Enum

Members

Member	Description
Connect	Instead of leaving gaps for empty worksheet cells in a data series, the gaps are filled with a connecting element.
Gaps	Leaves gaps for empty worksheet cells in a data series, which results in a segmented line.
Zero	Treats empty worksheet cells in a data series as zero values, so that the line drops to zero for zero-value data points.

Example

This example uses the EmptyValueStyle enumeration.

SpreadChart chart = this.fpSpread1_Sheet1.Charts[0];
ChartDataSetting dataSetting = new ChartDataSetting(EmptyValueStyle.Zero, true);
chart.DataSetting = dataSetting;
//chart.DataSetting.EmptyValueStyle = EmptyValueStyle.Zero;
//chart.DataSetting.ShowHiddenData = true;

Visual Basic

Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart(GetType(FarPoint.Win.Chart.BarSeries))
Dim dataSetting As New FarPoint.Win.Spread.Chart.ChartDataSetting(FarPoint.Win.Spread.Chart.EmptyValueStyle.Zero, True)
chart.DataSetting = dataSetting
fpSpread1.Sheets(0).AddChart(chart, 0, 0)
'chart.DataSetting.EmptyValueStyle = FarPoint.Win.Spread.Chart.EmptyValueStyle.Zero
'chart.DataSetting.ShowHiddenData = True

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.Chart.EmptyValueStyle

Reference

FarPoint.Win.Spread.Chart Namespace