Hello,
I am trying to create 2 charts with dynamic data. The data is in 3
columns: A,B,C.
A: time
B: temperature
C: humidity
I want to create 2 scatter plots, with data ranges as "A1:A<nn>, B1:B<nn>"
for chart 1
and "A1:A<nn>, C1:C<nn>" for chart 2.
(pic attached)
How do i do this via scripting? I am not able to figure out how to set this
range where the data is
split across separate columns.
I tried this:
var range1 = sheet.getRange("A1:A20,B1:B20");
var range1 = sheet.getRange("A1:A20,C1:C20");
But this doesn't work programatically, even though this is what is printed
when I select the range manually and insert a chart.
It gives the error "Range not found".
I want to either plot them into 2 separate scatter charts (preferred), or a
single scatter chart with multiple Y-axes.
I am able to create 2 series in a single chart using something like this:
var range = sheet.getRange(1,1,20,3);
But this plots the scatter chart with a single axis which is not what I
want.
any help is appreciated. thank you.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
