# Sparklines

Learn how to quickly visualize and analyze data at the cell level using sparklines in Excel. Add column, line, or winloss sparklines using methods and customize markers and points for effective data representation.

## Content

A sparkline is a small chart which can be applied to quickly visualize data and transform it in a compact form in a cell. It uses data from a range of cells to help you easily analyze data at the cell level.
You can set the sparkline type to column, line, or winloss by using the [AddSparkline](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.AddSparkline.html) method or use type-specific formulas to create different sparklines available.
The image below shows the [Vbar sparkline](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkline-func/hbar-vbar-sparkline) in action. It shows the trends in the temperature levels across a year in different cities and helps to quickly understand the high and low data points.
![](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sparklineexample.png)
Refer to the following list of topics while working with sparkline.

| **Topic** | **Content** |
| ----- | ------- |
| [Add Sparklines Using Methods](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkadd) | Add column, line, and winloss sparklines using methods and perform following operations: <ul><li>[Specifying Horizontal and Vertical Axes](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkadd/spwin-sparkaxis)</li><li>[Customizing Markers and Points](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkadd/spwin-sparkmarkers)</li><li>[Working with Sparklines](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkadd/spwin-sparktype)</li></ul> |
| [Add Sparklines using Formulas](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-sparkline/spwin-sparkline-func) | Add different types of sparklines such as pie, histogram, stacked, etc. using formulas. |
