February 2016
Beginner to intermediate
456 pages
9h 18m
English
Content preview from Going GAS
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 12. Charts
In Excel, manipulating charts makes up a fairly large part of the VBA footprint. When Apps Script for Sheets first became available, a number of services, including charts, made use of the UIApp service to embed visualizations and create UIs. The UIApp was deprecated in 2014, and these services have partially or fully migrated to alternative solutions (HtmlService, for example), or have been deprecated themselves (UIApp builder).
There are two ways of creating charts in Sheets. One is to use the EmbeddedChartBuilder, and another is to use the charts available in the Google Visualization API (which can be used from HtmlService). As with all Google services, it’s hard to predict which (if either) will be deprecated first, but given the reach of the Visualization API, and the continuing focus on Add-ons and other HtmlService-client-based capabilities, I would put my money on the Google Visualization API as the preferred way to create charts in the future.
Using the combination of the Google Visualization API and the HtmlService Dialog UI, you can create charts very much like the ones built by EmbeddedChartBuilder.
Chart Data
For these examples, I’ll use Table 12-1, which shows US domestic passengers flown by each airline in 2014. There are 125 airlines in the dataset, but I’ll concentrate on the top 10.
| Name | Passengers (000) | Carrier |
|---|---|---|
| Southwest Airlines Co. | 126,746 | WN |
| Delta Air Lines Inc. ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.