[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

Add Sparklines using Formulas

You can add different types of sparklines using their respective formulas in Spread for Winforms. The following table showcases the different sparklines available:

Types of Sparklines

Spread WinForms COLUMNSPARKLINE formula renders positive and negative source values as vertical columns above and below the horizontal axis. Column Sparkline

Spread WinForms LINESPARKLINE formula connects positive and negative source values with a line and displays colored marker points. Line Sparkline

Spread WinForms WINLOSSSPARKLINE formula displays positive values above the axis and negative values below it using equal-height columns. Winloss Sparkline

Spread WinForms AREASPARKLINE formula fills positive and negative value regions on opposite sides of the horizontal axis. Area Sparkline

Spread WinForms BOXPLOTSPARKLINE formula summarizes two data distributions with boxes, whiskers, averages, and median markers. Box Plot Sparkline

[Spread WinForms BULLETSPARKLINE formula compares measures with qualitative ranges, targets, forecasts, ticks, and maximum values in horizontal bars. Bullet Sparkline

Spread WinForms CASCADESPARKLINE formula displays positive and negative changes as stepped bars leading to a final cumulative total. Cascade Sparkline

Spread WinForms GAUGEKPISPARKLINE formula displays a current value against colored ranges, minimum, maximum, and target labels in a gauge. Gauge KPI Sparkline

Spread WinForms HBARSPARKLINE formula renders source values as horizontal bars with distinct colors and lengths inside worksheet cells. Hbar Sparkline

Spread WinForms VBARSPARKLINE formula renders source values as vertical colored bars with heights proportional to the cell values. Vbar Sparkline

Spread WinForms HISTOGRAMSPARKLINE formula groups source values into labeled bins and displays their frequencies as adjacent blue columns. Histogram Sparkline

Spread WinForms IMAGESPARKLINE formula displays country flag images beside China, India, and United States values in worksheet cells. Image Sparkline

Spread WinForms MONTHSPARKLINE formula visualizes daily values for January as a compact calendar grid with shaded cells. Month Sparkline

Spread WinForms YEARSPARKLINE formula visualizes daily values for 2016 as a full-year calendar heatmap with shaded cells. Year Sparkline

Spread WinForms PARETOSPARKLINE formula displays ranked percentages as colored horizontal bars with labels, target lines, and a highlighted position. Pareto Sparkline

Spread WinForms PIESPARKLINE formula converts source values into differently colored sectors of a compact pie chart inside a worksheet cell. Pie Sparkline

Spread WinForms SCATTERSPARKLINE formula plots two data series with markers, connecting lines, colored axes, and reference boundaries. Scatter Sparkline

Spread WinForms SPREADSPARKLINE formula visualizes the frequency distribution of source values as rows of green points around a reference line. Spread Sparkline

Spread WinForms STACKEDSPARKLINE formula divides each horizontal bar into labeled Product 1, Product 2, and Product 3 segments. Stacked Sparkline

Spread WinForms VARISPARKLINE formula compares positive and negative percentages with green and red bars centered on a zero reference. Vari Sparkline

!type=note

Note: The GrapeCity.Spreadsheet.DataVisualization.dll file is required to use the above sparkline functions. Users must add the DLL file in the project manually.