HomeХобби и стильRelated VideosMore From: Chris Betcher

Making live charts in Google Sheets

40 ratings | 12013 views
Short video explaining how to import live data into a Google sheet and create a chart to represent the data visualy.
Html code for embedding videos on your blog
Text Comments (11)
manoj yadav (3 months ago)
How to use =IF(A1="","",GOOGLEFINANCE(A1, "high",TODAY()-1))
senthil murugan (1 year ago)
can you help me below link data how update in google sheet. i need most active details https://economictimes.indiatimes.com/marketstats/exchange-50,pageno-1,pid-3,service-volumemovers,sortby-volume,sortorder-desc.cms
Pensées (1 year ago)
Thank you very much, but what if its not column and rows but just text on different lines, like a txt file with many lines?
sidfor911truth (1 year ago)
Very nicely done! Thank you for contributing to the world wide knowledge bank! You have a new subscriber.
billyboy402 (2 years ago)
You have a nice easy voice for teaching and explaining things , Great video
Chris Betcher (2 years ago)
Thank you!
exwhyz33 (3 years ago)
Really useful - Thanks. Does it work in Excel too ?
Chris Betcher (3 years ago)
+exwhyz33 I'm not sure, I don't use Excel.
Chris Betcher (4 years ago)
Here's a short video explaining how to import live data into a Google sheet and then create a chart to represent the data visually. The neat thing is the way it uses the ImportHTML function to slurp the source data from a different webpage, and then keep the spreadsheet (and chart) up to date whenever the source data changes. #t
Gary Johnston (4 years ago)
Love it. Thanks for the share!
Ralf Siegesmund (4 years ago)
that's just great to know. You really do these videos very nicely. You surely are using a tool which I don't know and will not have access to on pc nor my CB3 acer chromebook. Thanks for doing this video.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.