1

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.

3
  • 2
    Welcome to Web Applications. Short answer. No. What do yo mean by "I can work with google.visualization apis..."? – Rubén Dec 27 '20 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. – Naveen Rawat Dec 28 '20 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 '20 at 0:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.