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.

  • 2
    Welcome to Web Applications. Short answer. No. What do yo mean by "I can work with google.visualization apis..."?
    – Rubén
    Dec 27, 2020 at 22:26
  • @Rubén, I mean as per the documentation here, google chart have event listeners using google.visualization.events.addListener, but this so far seems like client side javascript to add charts. I would try to explore if I can somehow use these to embedd charts in google sheets, but not sure if that would work. Dec 28, 2020 at 0:34
  • 1
    AFAIK event listener can't be used with embedded in a spreadsheets charts, only on charts embedded in a web page. The available triggers that can be used on Google Sheets are described on developers.google.com/apps-script/guides/triggers and developers.google.com/apps-script/guides/triggers/installable
    – Rubén
    Dec 28, 2020 at 0:43


Your Answer

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