How to set Series Opacity in Google Sheets Embedded (Scatter) Chart with App Script

[Paul Coppinger]

How do I set this value using Google App Script?

I have followed the guidance in this reference, but there isn't an option listed to control the opacity of the series. Other chart types (such as Combo Chart) support this option, but Scatter Chart does not.

However, as you can see in the image, there is an option available through the user interface that allows the opacity of a series point in a Scatter Chart to be changed...so we know that it must be possible. How?

[cwl...@gmail.com]

I'm not sure if this will work, but if you are using a color name for the series color (e.g., "black"), try using a hex value (e.g.,  #000000). But also include in the hex value the opacity like this:   #00000080. 

I don't know if it will complain about the extra 2 digits or not. You can use this online converter to convert rgba to hex: 

https://rgbacolorpicker.com/rgba-to-hex

[cwl...@gmail.com]

Also check out this example,  and read the last sentence in that section about "dataOpacity".

[David Allcock]

I spent ages looking into this too.  In the end you do it *almost* like the first answer - namely:

  .setOption('series.0.color', 'rgba(255,0,0,0.1)')

This would set your series with index 0 to be 10% transparency red.

I have tried it, it works.  Hope this helps!