If the data
parameter of your chart object follows the interface of { sheetId, range }
with sheetId
as a Google Sheet id and range
as a Query Source Range, then a Query object will be created. The query will be sent automatically and update the chart with the data.
lava.chart({
type: "PieChart",
containerId: "chart_div",
data: {
sheetId: "1DwWSti6L3KRyJC0Wi33X3i-6lsZ2iStrhK7sxw7uoek",
range: "A1:B6"
},
options: {
width: 400,
height: 240,
is3D: true
}
});
lava.draw();
<div id="chart_div1"></div>