Lets you specify how you want empty worksheet cells in a data series to be shown in the chart.
Syntax
Visual Basic (Declaration) | |
---|
Public Enum EmptyValueStyle
Inherits System.Enum |
Members
Example
This example uses the EmptyValueStyle enumeration.
C# | Copy Code |
---|
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 | Copy Code |
---|
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
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also