You can insert a Dynamic Chart in Excel using this tutorial. Learn how to convert data into table to add a dynamic chart in a spreadsheet.

You may need to add cells in Google Sheets if your spreadsheet needs to contain more information than it currently has room for.

I'm pretty sure I need to use an ADO connection (which I've gotten to work) but I can't figure out how to add the data to the worksheet.<BR><BR>Any help would be GREATLY appriciated.

You can add a drop-down list in Google Sheets to better organize data within your spreadsheet. To add a drop-down list, you'll have to use the Data Validation function in Google Sheets. Here's how ...

How to insert a table using Excel Spreadsheet On the Insert tab, click the Table button in the Tables group. On the drop-down menu, select Excel Spreadsheet.