Visualize Data using Explore in Google Sheets

I’ve discussed adding charts to Google Sheets in various previous posts. Although the charts generator in Sheets is powerful, it can be a bit of a chore to create a chart just to quickly visualize some of your sheet data.

Good news. Google have added a cool new feature called Explore, which automatically creates charts and offers insightful comments based on the information contained in your data.

To use the Explore tool, highlight some sheet data and look for the Explore icon at bottom-right of the sheet.

Click image to enlarge

Click image to enlarge

If it’s greyed out, Google doesn’t think it can offer you any useful information on the range(s) you’ve highlighted. If the icon has turned green, though, click it to open a sidebar containing auto-generated charts and additional comments. Hover over a chart to see (via coloured highlights) which data in the spreadsheet has been used to create it:

Click image to enlarge

Click image to enlarge

Scroll down the sidebar to see a range of different views and analyses of your data.

Click image to enlarge

Click image to enlarge

Highlight different sets of data and you’ll see the charts change in real time. If you have edit privileges, you can drag and drop these charts directly into your spreadsheet, too (or use the insert chart icon that appears at the top-left of each chart).