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.

Syntax

=SPARKLINE(data,[options])

  • 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

Examples

 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.

IMAGE Function – Google Sheets

The IMAGE function lets a spreadsheet user insert an image into a cell. The source of the image is specified as a URL.

Syntax

=IMAGE(url,[mode],[height],[witdth])

  • url – The location of the image on the web – (“https://www.wheremypicis.com/mypic.png”). You must either use quotation marks around the URL or put it in another cell and reference it.
  • [mode] – Optional specification of how to size the image.
    • 1 – Resize to fit the cell. Maintains the same aspect ratio so the image does not look distorted.
    • 2 – Makes the image fit the entire cell. Will disregard the aspect ratio.
    • 3 – Maintains original size even it gets cropped.
    • 4 – Custom
  • [height] – If you specify 4 for custom mode, use this for the height.
  • [width] – If you specify 4 for custom mode, use this for the width.

Errors

#N/A – Not enough arguments. Possibly because you used option #4 but did not specify height and width.

Examples

 Live examples in Sheets

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