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

Black Friday banner dark

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

Sample Usage:

SPARKLINE(A1:F1)

SPARKLINE(A2:E2,{"charttype","bar";"max",40})

SPARKLINE(A2:E2,A4:B5)

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

Syntax

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

All Australian affiliates must use these banners.
Must Read-  Zuckerberg Launched Facebook for the Blind using Artificial Intelligence

One thought on “Google Drive : Now Add miniature charts or sparklines into individual cells in Sheets

Leave a Reply