GAS?Ŗ_?A?~?A?܂???ȂNJe??O???t???쐬?A?ύX?A?폜???邽?߂̊?{?FExcel VBA?v???O???}?[?̂??߂?Google Apps Script????i8?j?i1/2 ?y?[?W?j

?@?{?A?ځuExcel VBA?v???O???}?[?̂??߂?Google Apps Script?????v?ł́AGoogle???񋟂???uGoogle Apps Script?v?iGAS?j?̃v???O???~???O?ŁA?uGoogle Apps?v?𑀍삷????@???uGoogle Sheets?v?i?X?v???b?h?V?[?g?j?𒆐S?ɉ?????Ă????B

?@????́A?f?[?^????Ɋe??O???t???????@?????????B????????ׂ??????́A?P???ȃf?[?^?ł??A?O???t???ꏏ?ɂ??邾???ŁA??C?Ɍ??₷???Ȃ?B??????Ԕ???āA??????Ԕ???Ă??Ȃ??̂??A???̉Ȗڂ̕??ϓ_???ǂ??āA???̉Ȗڂ̕??ϓ_?????????ȂǁA???o?ɑi???邱?Ƃň?ڗđR?ƂȂ?B

?@?????????ۂɁA?u?O???t?v?͕K?v?s?Œ??ȑ??݂??BGoogle Apps Script?Łu?O???t?̐V?K?쐬?v?u?O???t?̕ύX?v?u?O???t?̍폜?v???s?????@?????????B

?@?g?p????f?[?^?͐}1?̂悤?ȃf?[?^???g?p????B?????̐ݒ?̓??j???[????蓮?ōs???Ă???B

?}1?@????g?p????u?w?ȕʂ̕??ϓ_?v?̃f?[?^

?V?K?ɃO???t???쐬????菇

?@?O???t???쐬????ɂ́A????́A?unewChart()?v???\?b?h???g?p????B???̃??\?b?h?̓V?[?g?ɐV?????O???t???쐬???邽?߂̃r???_?[?iEmbeddedChartBuilder?j??Ԃ??B

?@EmbeddedChartBuilder?̊e??ݒ?͈ȉ??̐ݒ???s???B

• addRange(range)?ŃO???t??????͈͂??w?肷??B
• setChartType?ŃO???t?̎?ށi?\1?j??ݒ肷??B
• setPosition(anchorRowPos,anchorColPos,offsetX,offsetY)?Ń`???[?g???V?[?g?ɕ\???????ʒu???w?肷??
• setOption(option,value)?ŁA?uoption?v?ɂ́utitle?v???w?肵?A?uvalue?v?ɂ̓^?C?g???Ƃ??ĕ\??????^?C?g???????w?肷??

?@?ł́A1?́u?V?K?ɃO???t???쐬????菇?v?ŁA?}1?̕\????ɖ_?O???t???쐬???Ă݂悤?B

?@?c?[?????j???[????u?X?N???v?g?G?f?B?^?v???N??????B?J?????G?f?B?^??ʂ???u?t?@?C???v???u?V?K?쐬?v???u?X?N???v?g?t?@?C???v?ƑI?????āA?u?_?O???t?̍쐬?v?Ƃ????t?@?C?????쐬????B?u?_?O???t?̍쐬.gs?v???ɁA???X?g1?̃R?[?h???L?q????B

function myPIEChartFunction() {
  var sheet=SpreadsheetApp.getActiveSheet();
  var range=sheet.getRange("A2:D10");
  var chart=sheet.newChart()
    .addRange(range)
    .setChartType(Charts.ChartType.BAR)
    .setPosition(2,6,0,0)
    .setOption('title','?w?N?ʕ??ϓ_');
  
  sheet.insertChart(chart.build());
}

?@?O???t??????͈͂?getRange?ŁuA2?`D10?v?͈̔͂Ƃ???i3?s?ځj?B

?@newChart?ŐV????EmbeddedChartBuider???쐬???鏀????????i4?s?ځj?B

?@addRange(range)?ŃO???t??????͈͂??w?肷??i5?s?ځj?B

?@setChartType?ŃO???t?̎?ނ??u?_?O???t?v?Ɏw?肷??i6?s?ځj?B

?@setPosition(2,6,0,0)?ŁA2?s?ڂ?6??ڂ͈̔͂Ɂu?_?O???t?v???쐬????i7?s?ځj?B

?@setOption?ŃO???t?̃^?C?g?????w?肷??i8?s?ځj?B

?@?V?[?g?Ɂu?_?O???t?v??}??????i10?s?ځj?B

?@?Ȃ??A5?`7?s?ڂ̍Ō?ɃZ?~?R?????i;?j???t???Ă??Ȃ??̂́AVisual Basic?ɂ?????With?`End With?\???Ɠ????悤?Ȃ??̂ƍl???Ă????B

With HogeHoge
  .Caption=?h?ق??ق??h
  .FontColor=?hRed?h
  .FontSize=24
End With

?@???s????Ɛ}2?̂悤?ɕ\???????B

?}2?@?w?ȕʂ̕??ϓ_???u?_?O???t?v?ŕ\?????ꂽ

?O???t??ύX????菇

?@???ɁA?}2?̃O???t???~?O???t?ɕω??????Ă݂悤?B

• sheet.getCharts()?ŃO???t?iEmbeddedChart?C???X?^???X?j???擾????
• EmbeddedChart??modify()???\?b?h??EmbeddedChartBuilder?C???X?^???X???쐬????
• Builder?̊e??ݒ???s??
• sheet.updateChart(chart)?ŃV?[?g?̃O???t???X?V????

?@?????ł́A?u?_?O???t?v???u?~?O???t?v?ɕύX???Ă݂?B

?@?c?[?????j???[????u?X?N???v?g?G?f?B?^?v???N??????B?J?????G?f?B?^??ʂ???u?_????~?O???t?ɕύX?v?Ƃ????t?@?C?????쐬????B?u?_????~?O???t?ɕύX.gs?v???ɁA???X?g2?̃R?[?h???L?q????B

function myFromBARToPIEFunction() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var chart = sheet.getCharts()[0];
  var newchart = chart
    .modify()
    .setChartType(Charts.ChartType.PIE)
    .build();
  sheet.updateChart(newchart);
}

?@getChart()[0]?Ŗ_?O???t???擾???ĕϐ?chart?ɑ??????i3?s?ځj?B?V?[?g??ɂ́u?_?O???t?v?????????\??????Ă??Ȃ??̂?[0]?ƋL?q????B

?@?ϐ?newchart??錾???āA?擾?????~?O???t?̏????i?[????i4?s?ځj?B

?@.modify()??EmbeddedChartBuilder?𐶐?????i5?s?ځj?B

?@?O???t?̎?ނɁu?~?O???t?v???w?肵?i6?s?ځj?A.build()?ŃO???t?̕ύX?𔽉f????i7?s?ځj?B

?@?Ō?ɁAsheet.updateChart(newchart)?ŃV?[?g??́u?_?O???t?v???~?O???t?ɍX?V????i8?s?ځj?B????ŁA?u?_?O???t?v???u?~?O???t?v?ɕύX?????B

?@???s????ƁA?}3?̂悤?ɂȂ?B

?}3?@?~?O???t?ɕύX???ꂽ

?@?~?O???t?ł͊w?N?ʂ̕\???ł͂Ȃ??A?S?w?N?̕??ς??Ƃ??āA?ȖڕʂɃp?[?Z???e?[?W?ŕ\??????Ă???B

?@??L?́A?V?[?g??ɑ??݂???O???t??ύX????ꍇ?̏????Ȃ̂Ŗ??͂Ȃ????A?ʏ?A?O???t???쐬???āA?V?K?̃O???t??lj????Ă????ƁA?V?????O???t???A??ɏ??Ԃɏd?Ȃ??ĕ\??????Ă????B?V?????O???t???쐬????ꍇ?A???ɃV?[?g??ɌÂ??O???t??????ꍇ?́A??????폜???Ă???A?V?K?̃O???t???쐬??????????????낤?B

?@???́A???̃O???t?̍폜?ɂ‚??ĉ?????悤?B