Spread for ASP.NET 11 Product Documentation
ShowMarkers Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ExcelSparklineSetting Class : ShowMarkers Property
Gets or sets a value that specifies whether data markers are displayed for each sparkline in this sparkline group.
Syntax
'Declaration
 
Public Property ShowMarkers As Boolean
'Usage
 
Dim instance As ExcelSparklineSetting
Dim value As Boolean
 
instance.ShowMarkers = value
 
value = instance.ShowMarkers
public bool ShowMarkers {get; set;}
Example
This example creates a sparkline in a cell.
FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView();
FarPoint.Web.Spread.Chart.SheetCellRange data = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 0, 0, 2, 2);
FarPoint.Web.Spread.Chart.SheetCellRange data2 = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 2, 1);

FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
ex.AxisColor = Color.SaddleBrown;
ex.ShowMarkers = true;
ex.DisplayEmptyCellsAs = FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero;

fpSpread1.Sheets[0] = sv;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 5;
sv.Cells[0, 0].Value = 2;
sv.Cells[0, 1].Value = 5;
sv.Cells[1, 0].Value = 3;
fpSpread1.Sheets[0].AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex);
Dim sv As New FarPoint.Web.Spread.SheetView
Dim data As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 0, 0, 2, 2)
Dim data2 As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 2, 1)
Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
ex.AxisColor = System.Drawing.Color.SaddleBrown
ex.ShowMarkers = True
ex.DisplayEmptyCellsAs = FarPoint.Web.Spread.Chart.EmptyValueStyle.Zero

FpSpread1.Sheets(0) = sv
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(0).ColumnCount = 5
sv.Cells(0, 0).Value = 2
sv.Cells(0, 1).Value = 5
sv.Cells(1, 0).Value = 3
FpSpread1.Sheets(0).AddSparkline(data, data2, FarPoint.Web.Spread.SparklineType.Line, ex)
See Also

Reference

ExcelSparklineSetting Class
ExcelSparklineSetting Members