SPARKLINE Function – Google Sheets

The SPARKLINE function enables a spreadsheet user to embed a miniature chart into a cell. They are similar to charts but much simpler to use. Sparklines can be in the form of bar charts, column and win loss, or line graphs.



  • data – The range of cells or array of data from which to make the sparkline. This is required.
  • [type] – Optional specifications of what type of chart. There are many options.

Video Explanation


 Live examples in Sheets

Go to this spreadsheet for the examples of the SPARKLINE function shown above that you can study and use anywhere you would like.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>