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()
This is the dataset I am using (screenshot from spreadsheet):

