Data Format 

Each row represents a point on your motion chart. Points can represent several dimensions of data, including time. The third column and any subsequent columns (optional) can be either a number or plain text. Learn more about spreadsheets in Visuals at Use Spreadsheet Data

 Column 1Column 2Column 3 (and beyond...)
Data Typeplain textdate, plain text, or numbernumberplain text

The category of the point


  • For example, "Alabama" or "Texas"

The time value for the point. Time can be in any of the data types above.


  • If the time is a year (for example, 2010): choose 'number'
  • If the time is a week number (in YYYYWww format) or a quarter (in YYYYQq format): choose 'plain text'
  • If the time is a month, day, or year: choose 'date'


The numeric value for a point.


  • These number columns will create values on the x and y axes.

The color category for the point.


  • Plain text columns create data categories in the legend

To learn more about motion charts, see Google's external motion chart guide and example template

Customization Options

Go to Common Customization Options

  • No labels