Now Google Sheets will automatically analyze data for you while working on the sheet. The new feature is called Explore. Highlight the sate and click the Explore tab in the bottom right corner of the Google Sheet. Instantly, create charts and perform analysis of the data. As you make changes to the data, the Explore view will automatically update and adjust the charts.