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.

Start freeSee the examples
KPIsSheet 1
ABC
2Jan1,180 Line chart: monthly active users rising from 1,180 in January to 1,820 in June
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=" & 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")

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.
Key
Anyone who can see the formula can see your public key. Use a short URL to hide it.
Start freeRead the URL spec