Interactive charts

[Joseph Hill]

Hi everyone, brand new to google charts so forgive me if I've missed something obvious.

What I'd like is a single chart linked to a spreadsheet, such that the end-user can choose what data to display.

Does google charts have this capability?

Many thanks, Joe

[Ray Thomas]

Yes it does, the user can choose a range of data to display. You need to look at the "Controls and Dashboards" section of the documentation - https://developers.google.com/chart/interactive/docs/gallery/controls 

Something you may find useful is the ability to, once the data has been downloaded into a datatable, carry out string and mathematical manipulation of the table. I did that to the table on http://hmsgambia.org/crewlist.htm but there's no reason you can't do that when drawing a chart if you need to.