All Questions
15 questions
1
vote
0
answers
60
views
Find the type of Google Sheet Chart tab using Google Sheets API/Apps Script
I have many sheets in a Google Sheet, I want to check the type of sheet via Google Apps Script
I know a chart sheet as well as a timeline sheet is a "OBJECT"
How to differentiate between the ...
- 3,198
0
votes
2
answers
372
views
Updating Chart's Title via Apps Script resets all other options and break chart's preferred presentation
I hope everyone is well!
We are struggling for days now to fix this issue.
We have a chart on google sheet that seems the following way:
https://www.dropbox.com/s/wwolb3166xf8sov/This%20is%20the%...
0
votes
1
answer
1k
views
How can we affect chart color with conditional formatting in Google Sheets?
In this Google Sheets workbook, I have conditional formatting based on checkboxes. I'd like to create a pie chart that will update based on the user-input data (boolean yielded from the checkbox data ...
- 1
0
votes
1
answer
462
views
Is it possible to set Chart options through the Google Sheets API?
I am able to update a "stacked area chart", however I cannot figure out how to set "Treat labels as text" on the Horizontal axis. (This is done in the UI by clicking "Edit Chart -> Customize -> ...
- 699
1
vote
2
answers
629
views
How to implement the makeApiCall() method after migrating Google Sheets API v3 to v4 with Oauth Authorization in Javascript
Google has build v4 of the Google Sheets API but the documentation of this is still at v3. There are no full examples of how to implement a simple OAuth authentication with Google Sheets API v4.
I ...
- 67
0
votes
1
answer
339
views
What are the minimum scopes needed in an oauth2.0 to grant a web app access to a user’s google spreadhseets?
I’m using google visualization charts and timeline to display some data on a simple webpage.
The data for the charts comes from a google sheet.
The google sheet is set to private and therefore I need ...
- 67
0
votes
2
answers
804
views
Authorizing Google Charts to access private spreadsheets
I am trying to create a Web App using Google Apps Script to query data from my Google Sheet using Google Charts.
I have been able to successfully query the spreadsheet when the Google Sheet is ...
- 952
2
votes
1
answer
669
views
Google Sheet Pie Chart JS : Slices offset method not working?
I've been spending (lots of) time trying to figure out how to explode/split a Pie Chart within Google Sheets /
(eg. Using the slices setoption in Google Apps Script)
http://fiddle.jshell.net/6d5fLwnm/...
- 21
0
votes
1
answer
110
views
Is there a way to automatically display a sum from a google spreadsheet on a webpage?
I'm using google charts and using a jquery to grab data from a google spreadsheet. It's allowing me to have the charts update as I add more data (in this case a listing of individual donations) in the ...
2
votes
1
answer
1k
views
Can I reposition a modeless dialog in Google Sheets?
Using Google Apps Script, how can I position a modeless dialog?
Here my Code.gs function that opens the modeless dialog and renders an existing html file into it:
ui = SpreadsheetApp.getUi();
...
- 25
3
votes
1
answer
1k
views
Y Axis in Google Charts increments in "General 1, General 2" etc - Java Script
I have a problem with my dashboard in Google Charts. Currently everything works except that the column chart displays a string rather than an integer on the Y axis.
I find the documentation on the ...
- 299
1
vote
2
answers
295
views
GAS - Chart API Deprecated
I looked at my 'Execution Hints' and saw this.
"Chart API is deprecated."
I copied the chart codes directly from here
https://developers.google.com/apps-script/reference/charts/column-chart-builder
...
- 391
1
vote
1
answer
2k
views
formatting trendline using setoption() in google apps script
I am using Google Apps Script to create a scatterplot with a trendline. I have taken an idea from Google Charts API on how to create the trendline, and this has been successful. But, the approach to ...
- 13
1
vote
2
answers
974
views
Configuring DataView from two sheets in the same Google Spreadsheet file for Google Charts DataSource
I am finding it hard to get this answer. I am looking into creating a Google Chart Dashboard for my client and have a Year, Month, Day filter however, their records for 1 year are over 4000 rows, I ...
- 11
2
votes
2
answers
1k
views
How to update or manage Annotated Time Line chart through google spreadsheet app's custom code?
I am working on a spreadsheet of me at google spreadsheet. You can visit it here.
If you visit the page you will see 2 charts at the current sheet (Graph Input). The first one is the embedded one ...
