Update X-Axis & series

48 views
Skip to first unread message

Le pirate noir

unread,
Feb 22, 2022, 5:04:12 PM2/22/22
to Google Apps Script Community

Clark Lind

unread,
Feb 23, 2022, 7:54:15 AM2/23/22
to Google Apps Script Community
That is a pretty wide and general area to cover. Can it be done? Yes.  There is no easy answer without knowing a lot more about your specific situation. 

Here is the chart reference so you see what I mean.

Martin Hawksey

unread,
Feb 23, 2022, 3:11:37 PM2/23/22
to Google Apps Script Community
As noted not much to go on but can relate with the issue of finding the right chart options. Watching a recent episode of Sheets to Apps on How to build a Google Analytics Dashboard with Apps Script and Google Sites I learned that you can use the Google Sheets Macro Recorder to record a modification to a chart which then exposes all the setOptions() . Something to note is as the Charts  Service appears to only be a partial implementation of EmbeddedChart  used in SpreadsheetApp Service not all of the ChartTypes and options are implemented, not sure if this includes range.
Reply all
Reply to author
Forward
0 new messages