The default spreadsheet has a separate sheet for the Graphs information - to populate the left side of the slide, and the Settings information - to populate the small and large bubbles on the right hand side of the slide.

The Line Value Prefix (e.g. $) on the Settings sheet is required for the line to appear on the left-hand chart.
Sheet | Data Column | | Supported Formatting |
Graphs | Label | Required | Free format e.g. Dec-16
|
| Bar Value | Required | Numeric |
| Line Value | Required | Numeric |
Settings | Small Bubble Value | Required | Numeric |
| Small Bubble Label | Required | Free format |
| Large Bubble Value | Required | Numeric |
| Large Bubble Label | Required | Free format |
| Line Value Prefix | Required | Symbol, e.g. $
|