For anyone who has used a generic spreadsheet application in the past, Google Spreadsheets becomes a natural starting point when learning about Google visualizations. Data entry, chart creation, and formula functionality in Google Spreadsheets is extremely similar to other generic spreadsheet applications. Yet, a significant difference between traditional spreadsheet charting applications and Google Spreadsheets is the ability to enhance capabilities by overlying Apps Scripts, and re-create and enhance the same chart with the Visualization API. Direct API access allows a developer to include advanced features such as style customization and dynamic manipulation of the data.
Spreadsheets are built from Google infrastructure, and thus inherit some dynamic capabilities from the Visualization API. These features are generally presented as static capabilities in Spreadsheets, and can only be modified if control has been offered through the GUI (for example, colors and fonts). Then...