the approach I’ve tried was particularly easy to find in google docs help, which I’m quite impressed with since I’ve used it a few times recently. Charts: Publishing a chart to a web page or blog post..
Followed the tips on a spreadsheet and embedded the chart below. It just does an image so I’m not sure if this updates when the underlying data updates. The src value is to the spreadsheet so I assume it does.
My first attempt was actually a google gadget. I didn’t realise that. Left it in anyway to see if I can get it working and as an example.
I’ve received some great examples and advice. Just had to include them hear.