Spread ASP.NET 17
Spread for ASP.NET 17 Product Documentation / Developer's Guide / Customizing the Appearance / Customizing the Appearance of a Cell / Using Sparklines / Customizing Markers and Pointers
In This Topic
    Customizing Markers and Pointers
    In This Topic

    You can show markers or points in the sparkline graphs. The following image displays the points in a line sparkline. You can specify different colors for low or negative, high, first, and last points.

    Markers and Pointers

    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 SeriesColor property applies to the line for the line spark type. The MarkersColor property is only for the line type sparkline. See the ExcelSparklineSetting class for a list of sparkline properties and additional code samples.

    Using Code

    1. Specify a cell to create the sparkline in.
    2. Specify a range of cells for the data.
    3. Set any properties for the sparkline (such as ShowFirst and FirstMarkerColor).
    4. Add the sparkline to the cell.

    Example

    This example creates a line sparkline in a cell and shows different markers and colors.

    C#
    Copy Code
    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.ShowNegative = true;
    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 = 6;
    fpSpread1.Sheets[0].ColumnCount = 6;
    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); 
    
    VB
    Copy Code
    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 = 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 = 6
    FpSpread1.Sheets(0).ColumnCount = 6
    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) 
    

    Using the Spread Designer

    1. Type data in a cell or a column or row of cells in the designer.
    2. Select a cell for the sparkline.
    3. Select the Insert menu.
    4. Select a sparkline type.
    5. Set the Data Range in the Create Sparklines dialog (such as =Sheet1!$E$1:$E$3).
    6. Select OK.
    7. Select the sparkline cell, select the Marker Color or Sparkline Color icon, and set the colors.
    8. Select Apply and Exit from the File menu to save your changes and close the designer.
    See Also