Sumo - The Best Website Traffic Tools -

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

Sample Usage:

SPARKLINE(A1:F1)

Unlimited Photo Storage

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

website templates powered by MotoCMS

About the author

Henry Carter

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

Leave a Comment

1 Comment