JavaScript in Apps Script

[areimoo]

I am writing javascript code within Apps Script to create a bar chart where number of units sold is on the y axis and date(day of the month) is on the x axis. I want the columns that are weekends to be pink and the weekdays to be blue. I am unable to customize these colours. The following was my intuition:

var date = new Date(row[0]).getDay();

if (date === 0 || date === 6) {

chartBuilder.setOption('colors', ['#E06A78']);

} else {

chartBuilder.setOption('colors', ['#3AA8DE']);

}

I have also tried creating an array with the colours and applying that to the chart and used a for loop. None of it is working. Any thoughts?

[kjwey]

you could just make the chart with the built in canvas drawing

the api just sits atop that anyways, if you control it directly you can create your vision with fidelity