You can show markers or points in the sparkline graphs. You can specify different colors for low or negative, high, first, and last points.
The high point is the point for the largest value. The low point is the smallest value. The negative point represents negative values. The first point is the first point that is drawn on the graph. The last point is the last point that is drawn on the graph. The MarkersColor property only applies to the line sparkline type.
The following example sets marker colors and creates a sparkline with the SetSparkline method.
| CS |
Copy Code |
|---|---|
| GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5); GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting(); ex.AxisColor = System.Windows.SystemColors.ActiveBorderColor; ex.LineWeight = 1; ex.ShowMarkers = true; ex.MarkersColor = Color.FromArgb(255, 255, 0, 128); ex.ShowFirst = true; ex.ShowHigh = true; ex.ShowLast = true; ex.ShowNegative = true; ex.FirstMarkerColor = Color.FromArgb(255, 163, 73, 164); ex.HighMarkerColor = Color.FromArgb(255, 49, 78, 111); ex.LastMarkerColor = Color.FromArgb(255, 0, 255, 255); ex.NegativeColor = Color.FromArgb(255, 255, 255, 0); gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2; gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 5; gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 4; gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = -1; gcSpreadSheet1.Sheets[0].Cells[0, 4].Value = 3; gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex); gcSpreadSheet1.Invalidate(); | |
| VB.NET |
Copy Code |
|---|---|
| Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5) Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting() ex.AxisColor = System.Windows.SystemColors.ActiveBorderColor ex.LineWeight = 1 ex.ShowMarkers = True ex.MarkersColor = Color.FromArgb(255, 255, 0, 128) ex.ShowFirst = True ex.ShowHigh = True ex.ShowLast = True ex.ShowNegative = True ex.FirstMarkerColor = Color.FromArgb(255, 163, 73, 164) ex.HighMarkerColor = Color.FromArgb(255, 49, 78, 111) ex.LastMarkerColor = Color.FromArgb(255, 0, 255, 255) ex.NegativeColor = Color.FromArgb(255, 255, 255, 0) GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2 GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 5 GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 4 GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = -1 GcSpreadSheet1.Sheets(0).Cells(0, 4).Value = 3 GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Line, ex) GcSpreadSheet1.Invalidate() | |