Spreadsheet Format

Each row represents a data point on the area chart. The chart below shows what data should be included in each column. Learn more about using spreadsheets with Visuals at Use Spreadsheet Data.

 Column 1Column 2Column 3 (and beyond...)
Data Typeplain text, number, date, time, or date timenumbernumber

The x-axis value for your data point. This makes your chart discrete (plain text) or continuous (number, date, time, or datetime).

The value for your point on the y-axis. This creates your first line of data.

A different value for your point on the y-axis. This creates a second line of data.


  • You can have as many additional columns of data as you need. Each column creates a data line.


Use this spreadsheet template to guide your data entry. To use it, just copy and paste the cells into your own Google sheet. You can click on a cell to get more information about a specific column, or reference the table above. 

Customization Options

Learn about options at Common Customization Options

  • No labels