Static style options are those that are generally not intended for end-user interaction. Fonts, axis labels, colors, and filters fall under the static category. However, many of these options can become interactive as user controls and dashboards are added to the chart.
Customizable formatting options for Spreadsheets can be found in the Chart Editor. Instructions on using the built-in Spreadsheets Chart Editor was discussed in Chapter 3, Spreadsheets, Charts, and Fusion Tables. Options to customize the look of the data table itself are found under the Format menu tab. Additionally, the Conditional formatting… option under the Format tab includes conditional logic options similar to those found in any basic spreadsheet application. (Example logic: Color the cell green if value is above 10.)
For Spreadsheets, non-API styling capability does not extend beyond basic spreadsheet logic and Chart Editor options. It is possible to use the Visualization API inside an Apps Script...