Create Google Line Chart - Time Series

This article provides a step by step example of how to create a Google Line chart.

For this type of Chart, choose a report that contains a time series and limit the data collected to two columns. If your report contains more than two columns, you can add a pivot to limit the data to two columns.

Google documentation on Line Chart API can be found at

1. Choose a Report for the Chart

NOTE:  In this example the calendar_date column contains the time series data

2. Adjust Display Name for chart columns

Display Names may be changed by clicking on the name in the Display Name column

Ensure that the Display Name for the columns that you will be charting do not contain spaces


3. Add the Chart

  1. Navigate to the Charts and Pivots tab
  2. Click the Add Chart button

3.1. Set Chart type

  1. Select Google Line


4. Full Chart Editor Displays

  1. Set Chart NameSelect Region data column as X-axis values
  2. Set X-axis title
  3. Set Y-axis title

Save & preview

5. Preview Chart

If the chart meets expectations:

  1. Close preview
  2. Update live report 

6. Chart displays in Report Viewer