Google Drive : Now Add miniature charts or sparklines into individual cells in Sheets

Google Drive,Creates a miniature chart contained within a single cell. Here is official announcement by Google Drive team.

Sample Usage:




Liquid Web Managed Word Press

SPARKLINE(A1:A5, {"charttype","column"; "axis", true; "axiscolor", "red"})


SPARKLINE(data, [options])

  • data – The range or array containing the data to plot.
  • options – [ OPTIONAL ] – A range or array of optional settings and associated values used to customize the chart.
    • If referencing a range, options should be two cells wide where the first cell is the option and the second cell is the value that option is set to.
    • The "charttype" option defines the type of chart to plot, which includes:
      • "line" for a line graph (the default)
      • "bar" for a stacked bar chart
      • "column" for a column chart
      • "winloss" for a special type of column chart that plots 2 possible outcomes: positive and negative (like a coin toss, heads or tails).


    • sparkline-techblogcorner

Read more about this here

Oh hi there 👋 It’s nice to meet you.

Sign up to receive awesome content in your inbox, every month.

We don’t spam! Read our privacy policy for more info.

Henry Carter is a Writer & Blogger at NeotericUK Ltd. He has done his graduation from Newcastle University, UK . Follow me on Google+

0 thoughts on “Google Drive : Now Add miniature charts or sparklines into individual cells in Sheets”

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.