Embed compelling charts from my Google Speadsheets into wordpress

I've been building a private dashboard for investors to see Revenue, Expenses, Deposits Made, and other data from my private company. Other 3rd party data like weather reports also pulled.

I need someone failure with how to take spread sheet data to make really good charts as interactive as possible. This dashboard is suppose to look similar to a bank account where they can see important information regarding their account.

Applications have to fill out the from and the admin can either approve or deny their account prior to access is granted. If you have a background in big data and have other data-sets related to farming or the agricultural sector, that would be a bonus.