I had a question about my assignment. The main this is for this assignment we have been given links to Google Spreadsheets with data in them and I am trying to link that data into 3 different charts and 1 control. My problem is that my code is not correct when i try to do a query function that will allow for the charts to show so please help if possible here is some of the requirements.

Use Google Chart Tools (JavaScript API) to visualize a data set of your choice. A few examples are listed below. Create a dashboard with at least three (3) charts and at least one (1) control.

You dont have to visualize all the data in the spreadsheet. Select the columns that you find useful or interesting.

Read the data directly from a Google Spreadsheet. Dont manually enter the data in the code. Dont load data from a local file.

I just want to get some general understanding of the code I already have my own but for some reason my three charts are not showing at this time.