Visualizing Google Spreadsheets
Google provides easy to use tools to visualize data called Google Chart Tools. They have a rich gallery of interactive charts and data tools that are customizable, support all browsers and are free to use.
An example of using a Google spreadsheet as a datasource is Tribal Climate Change Funding Guide. The page displays a table of data that CASIT Web Services set up using the Google visualization API combined with some PHP code to add specific filters that use the Google data queries. The page was set up based on guidelines from Google Chart tools documentation and from Katie Piatt’s Blog.
Quick link: Introduction to Using Chart Tools.