CODEWITHSUNDEEP
google-apps-script
rough68fish
rough68fish

Reputation: 11

How to reference an existing chart in a google spreadsheet

I want to make changes to existing google charts in my spreadsheet when new data is entered. I have and onEdit function that is working nicely but I cannot figure out how to get a "pointer" to the existing chart objects in the spreadsheet.

Upvotes: 1

Views: 1403

Answers (2)

Thibault Pouget
Thibault Pouget

Reputation: 81

See Programmatically Managing Charts in Spreadsheets:

Also, Other Google I/O announcements may be of interest

Upvotes: 1

Henrique G. Abreu
Henrique G. Abreu

Reputation: 17792

I hate to have to break the bad news. But it is just not possible. There's no API at all to deal with charts in spreadsheets.

If it's not a problem in your use-case. You could generate the chart image/url automatically from the script using the Google Charts Tools and then insert the it on the spreadsheet.

Upvotes: 0

Related Questions