Use it in

Charts in Google Sheets.

=IMAGE() shows a chart inside a cell. Build the URL from your cells and the chart follows the numbers.

KPIsSheet 1
ABC
2Jan1,180 Line chart: monthly active users rising from 1,180 in January to 1,820 in June, with the watermark every unsigned chart carries
3Feb1,320
4Mar1,290
5Apr1,510
6May1,640
7Jun1,820

Set it up.

  1. Size it for the cell

    Use w=400&h=200, or the size of the merged cells you want it in.

  2. Build the URL from cells

    TEXTJOIN turns a column of numbers into the comma list the URL needs.

  3. Wrap it in IMAGE

    The cell shows the PNG. Change a number and the cell shows the new chart.

=IMAGE("https://c.renderchart.com/?key=KEY&type=line&w=400&h=200&smooth=1"
  & "&x=" & ENCODEURL(TEXTJOIN(",", TRUE, A2:A7))
  & "&y=" & TEXTJOIN(",", TRUE, B2:B7))
=IMAGE("https://c.renderchart.com/?key=rc_pub_live_7Hq2mX9pLk4vN8sT1wEa&type=line&x=Jan,Feb,Mar,Apr,May,Jun&y=1180,1320,1290,1510,1640,1820&title=Monthly%20active%20users&smooth=1&w=400&h=200")

Which kind of URL.

Unsigned, always

  • A formula can't sign: the signature covers the numbers, and your secret key must never go in a sheet. So a chart built from cells is an unsigned URL.
  • Unsigned charts carry the small renderchart.com watermark on every plan, paid plans included, as in the chart above.
  • The key must accept unsigned URLs. Keys you create on a paid plan start as signed-only, so untick that, or give your sheets a key of their own and keep the rest signed-only.
  • On a paid plan, new charts from the sheet stop at your monthly allowance unless the sheet's key allows extra renders for unsigned URLs. Charts already drawn keep showing.
  • Anyone who can see the sheet can see the key and the numbers. The most they can do with the key is make watermarked charts on your allowance; a monthly render limit on the key caps that.
  • A chart that doesn't need to follow your cells can be a signed or short URL made in the app instead, with no watermark on a paid plan.

Unsigned, signed and short URLs compared

Worth knowing.

Renders
Each new set of numbers is one render. Opening the sheet again, or sharing it, comes from cache.
Labels
Keep labels short; 11px labels still read in a 400 x 200 cell.
Short URLs
A short URL hides the key, but it holds saved data, so it won't follow your cells.