Create Google Line Chart from Pivot Table
In many cases your reports return multiple columns of data. If you want to create simple two axis reporting on this data with a JavaScript chart, you can create a Pivot Table on the report and then associate a chart with that Pivot Table.
This article provides a step by step example of creating a Google Line chart using the results from a pivot table.
Google documentation on the Line Chart API can be found at https://google-developers.appspot.com/chart/interactive/docs/gallery/linechart
1. Select a Report
2. Add Pivot
- Navigate to Charts and Pivots tab
- Click Add Pivot button
3. Define Pivot Parameters
- Select Row Values
- Choose Column to Aggregate
Save
4. Full Pivot Editor Displays
- Input a meaningful Name
- Adjust any values on the Pivot Editor
Save
5. Associate a Chart with the Pivot Table
- Navigate to the Pivot Charts tab
- Click New Chart button
5.1. Select Chart Type
- Select Google Line as Chart type
Save
6. Full Chart Editor Displays
- Input a meaningful name for your chart
- Optionally edit X-axis title
- Optionally edit Y-axis title
Save & publish
0 Comments
Add your comment