It has finally happened, Google has included a graphing function in their Google Docs Spreadsheet and it is pretty cool indeed. The spreadsheet has always been pretty neat to use but now with the this latest function things have really stepped up a notch. One thing that is quite attractive for me as a teacher is that it doesn’t have all of the “bells and whistles” of the commercial alternatives. This means that my students are not distracted by making lots of cosmetic changes instead they can better concentrate on the task of dealing with the data.
Just because it is simpler though doesn’t mean it only has basic functionality. Using the Tabs you can do simple sorts, freeze frames, add formulas and best of all graph your work choosing from a range of basic graphs. The graphs are dynamic too, changing as the data is modified, nice.
Now all I need to know is how I can embed them into a blog, (though I’ve looked around I can’t seem to find how you can do this and ‘cos I’m off to bed that will have to wait for another time
. Click the pic though and you can see my test.
Filed under: Tools, Uncategorized










“Now all I need to know is how I can embed them into a blog”
Go to the “publish” tab (upper right).
Click “more publishing options”.
Under the format selector – choose “HTML to embed in a web page”
Choose the other options you want – and “Generate URL”, which, in this case generated HTML you can copy and paste in your blog…
You can easily publish a chat only by selecting the range of cells which encompass that chart ….
A hidden option is to turn grid lines off by adding &gridlines=false to the URL…
Have Fun!