Skip to main content Skip to footer

Spread Windows Forms Designer and Sparklines

You can use the Spread Windows Forms designer to quickly design a sparkline. Start the Spread Designer by selecting the FarPoint.SpreadDesigner.EXE from the product bin folder or by right-clicking on the FpSpread component on your form and then choosing Spread Designer. You can create a sparkline using the following steps:

  1. Add data to the designer. SpreadWinDesignerSparkTest Data
  2. Select the Insert tab. SpreadWinDesignerInsert Insert Tab
  3. Select a sparkline type (Sparklines section). The Create Sparklines dialog is displayed. SpreadWinDesignerAddSpark Sparkline Type
  4. Specify the data range and the sparkline location. SpreadWinDesignerSparkRange Sparkline Range and Location
  5. The Sparklines tab is displayed once you select a type. SpreadWinDesignerSOptions Sparkline Options
  6. The following options are available:

    Item

    Description

    Edit Data

    This option allows you to change the sparkline data.

    Line, Column, or Win/Loss

    This option allows you to change the type of sparkline.

    High Point

    This option specifies whether to display the point for the largest value.

    Low Point

    This option specifies whether to display the point for the smallest value.

    Negative Point

    This option specifies whether to display points for negative values.

    First Point

    This option specifies whether to display the first point on the graph.

    Last Point

    This option specifies whether to display the last point on the graph.

    Markers

    This option specifies whether to add points for all the data (only applies to the line sparkline).

    Sparkline Color

    This option specifies the line color for the line sparkline or the data point color for the column or winloss sparkline.

    Marker Color

    This option specifies the color of the data points for the line sparkline or the color of the special data points for the column or winloss sparkline (for example, first point).

    Weight

    This option specifies the thickness of the line for the line sparkline.

    Axis

    This option specifies the axis type, how the data is plotted, whether to display an axis, and the minimum and maximum settings for the vertical axis. The horizontal axis is only displayed if the data contains negative values.

    Group

    This option allows you to group selected sparklines so they can share formatting and scaling options

    Ungroup

    This option removes the grouping from selected sparklines.

    Clear

    This option clears the selected sparklines.

    If the chart type is column or winloss, then selecting point options changes the color of the point indicator. Selecting point options with the line sparkline adds a data point to the line.

  7. Specify the sparkline options to complete your sparkline. SpreadWinDesignerSparkOptions Completed Sparklines

For more information about sparklines, refer to: http://sphelp.grapecity.com/WebHelp/SpreadNet9/WF/webframe.html#spwin-sparklines.html.

MESCIUS inc.

comments powered by Disqus