How to share or embed a Google Sheets chart that updates instantly (no need to wait for 5 minutes)

Solution

Step 1 — Copy & change the link in the browser url bar

Copy the url from the sheet where your chart is
  1. Replace the “edit#” part in the url with: htmlembed/sheet?
  2. Next, get the cell number where your chart is and add it in the following format to the end of the url: &range=F2
    If you don’t know what the cell number for your chart is, just cut and paste the chart in any cell. That will be the cell you’ll use. My chart is at F2 as you can see.
Click on the Share button to change your sharing preferences
Change your sharing preferences accordingly
  1. Paste your url in a new browser bar
  2. Change your data range.
  3. Refresh the chart url and see how it updates instantly.

Summary

Here’s how to share or embed a Google Sheets chart publicly and make it update instantly when you change data ranges:

  1. Copy the url from the browser bar and change the url as above
  2. Set your sharing preferences
  3. Share or embed the url

--

--

Husband to a beautiful wife. Noob dad. Lead product designer @Luno. Learner writer at viljoen.space. Finds solace in gardening.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Steyn Viljoen

Steyn Viljoen

Husband to a beautiful wife. Noob dad. Lead product designer @Luno. Learner writer at viljoen.space. Finds solace in gardening.