I’ve been messing around with adding charts/graphs to web pages that can pull their data from a Google Doc Spreadsheet. Â That way the chart is updated when the data is updated, instead of placing a static image of a chart on the page. Â Conveniently the Google Visualization API makes creating attractive visualization of data fairly easy. Â All you have to do is set up a Google Docs Spreadsheet, then do the following steps:
To get the data source url for Google Spreadsheet data sources follow these steps:
- Create a spreadsheet in the format expected by your gadget.
- Select the range of cells you want to display in the gadget.
- From the toolbar, click ‘Insert’ and choose ‘Gadget’.
- Choose an existing gadget or select ‘Custom’ as the gadget type, enter the URL of your gadget XML specification and click ‘Add’.
- In the gadget title, click the arrow icon on top right of the title bar.
- Choose “Get query data source url…” from the popup menu.