Hello,
I've been spending lots of time trying to figure out how to explode/split a
Pie Chart within Google Sheets /
(eg.
https://stackoverflow.com/questions/38919329/using-the-slices-setoption-in-google-apps-script?rq=1
)
http://fiddle.jshell.net/6d5fLwnm/4/
This works outside google sheets using Google Visualisation
e.g. PieChart
*.setOption ('slices', Value)*
*e.g. {3: {offset : 0.3};*
But this method of the Google Chart Builder/Embedding
is not working AT ALL in my "google sheet assigned script" (see below for
code)
Any ideas/experience on that ? Is this deprecated somehow ?
(other .setOption methods works : Colors for example)
My sheet has a 3 columns (therefore selecting B2:C5), 4 lines, simplified
for testing purposes.
Here is the code :
function GeneratePie() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange("B2:C5");
var pie = sheet.newChart()
.setChartType(Charts.ChartType.PIE)
.addRange(range)
.setPosition(5,6 ,5, 5)
//.setTitle("This is the title of my chart")
.setOption('slices', {
0: {offset: 0.05},
1: {offset: 0.15},
2: {offset: 0.25},
3: {offset: 0.35}
})
.setOption('title', 'Updated!');
// another try
slicces[0] = '{offset: 0.2}';
pie.setOption('slices', slicces); // wrapper is the ChartWrapper */
pie.setOption('title', 'Updated2!');
sheet.insertChart(pie.build());
var chart = sheet.getCharts()[1];
chart = chart.modify()
.setOption('title', 'Updated ZZZZZZZ!')
.setPosition(5,6,6,6)
.setOption('slices', {
0: {offset: 0.05},
1: {offset: 0.15},
2: {offset: 0.25},
3: {offset: 0.35}
})
.build();
sheet.updateChart(chart);
}
All comments are welcome...
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.
