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
| A | B | C | |
|---|---|---|---|
| 2 | Jan | 1,180 | ![]() |
| 3 | Feb | 1,320 | |
| 4 | Mar | 1,290 | |
| 5 | Apr | 1,510 | |
| 6 | May | 1,640 | |
| 7 | Jun | 1,820 |
Set it up.
Size it for the cell
Use w=400&h=200, or the size of the merged cells you want it in.
Build the URL from cells
TEXTJOIN turns a column of numbers into the comma list the URL needs.
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.
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.
