I am trying to embedded column chart in Google sheets and would like to capture events like which column was clicked, then use the info to highlight certain cells. Is that even possible in embedded Google charts within Google spreadsheets?

So far, I have found that:

  1. I can get Class EmbeddedChart's object and get/modify its attributes like title.

  2. I can work with google.visualization apis (which allows event capture), but do not know how to embed them to google sheets.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.