Spread for ASP.NET 9.0 Product Documentation
MarkersColor Property
Example 


Gets or sets a value that specifies the color of the data markers for each sparkline in this sparkline group.
Syntax
'Declaration
 
Public Property MarkersColor As Color
'Usage
 
Dim instance As ExcelSparklineSetting
Dim value As Color
 
instance.MarkersColor = value
 
value = instance.MarkersColor
public Color MarkersColor {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,1, 5);
FarPoint.Web.Spread.Chart.SheetCellRange data2 = new FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5,0,1,1);

FarPoint.Web.Spread.ExcelSparklineSetting ex = new FarPoint.Web.Spread.ExcelSparklineSetting();
ex.AxisColor = Color.SaddleBrown;
ex.ShowFirst = true;
ex.ShowHigh = true;
ex.ShowLow = true;
ex.ShowLast = true;

ex.FirstMarkerColor = Color.Blue;
ex.HighMarkerColor = Color.DarkGreen;
ex.MarkersColor = Color.Aquamarine;
ex.LowMarkerColor = Color.Red;
ex.LastMarkerColor = Color.Orange;
ex.ShowMarkers = true;
        
fpSpread1.Sheets[0] = sv;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 10;
sv.Cells[0, 0].Value = 2;
sv.Cells[0, 1].Value = 5;
sv.Cells[0, 2].Value = 4;
sv.Cells[0, 3].Value = 1;
sv.Cells[0, 4].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, 1, 5)
Dim data2 As New FarPoint.Web.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1)

Dim ex As New FarPoint.Web.Spread.ExcelSparklineSetting()
ex.AxisColor = System.Drawing.Color.SaddleBrown
ex.ShowFirst = True
ex.ShowHigh = True
ex.ShowLow = True
ex.ShowLast = True

ex.FirstMarkerColor = System.Drawing.Color.Blue
ex.HighMarkerColor = System.Drawing.Color.DarkGreen
ex.MarkersColor = System.Drawing.Color.Aquamarine
ex.LowMarkerColor = System.Drawing.Color.Red
ex.LastMarkerColor = System.Drawing.Color.Orange
ex.ShowMarkers = True

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

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

ExcelSparklineSetting Class
ExcelSparklineSetting Members

 

 


Copyright © GrapeCity, inc. All rights reserved.