Create Combo Chart (Bar with Candlestick) in Sheet using Google Apps Script

Viewed 371

I am trying to create a combo chart in sheet embedded script. The chart needs to have a combination of Bar Chart and Candlestick Chart.

I am able to create a similar chart on jsfiddle using Google Charts JS library.

But when I try a similar approach on Apps Script, I get a Bar Chart with Line Chart.

My current code and the result are given below:

var chart = chartSheet.newChart()
  .setChartType(Charts.ChartType.COMBO)
  .addRange(range)
  .setPosition(25, 8, 0, 0)
  .setOption('seriesType', 'candlesticks')
  .setOption('series', {1: {type: 'bars'}})
  .build()

chart screenshot

This is the dataset I am using (screenshot from spreadsheet):

sheet structure screenshot

0 Answers
Related