Charts from Google Sheets using Vizydrop

Oleg Seriaga
Vizydrop
Published in
2 min readJan 31, 2019
The answer to this puzzle at the end of the article

Google Sheets is very popular for creating spreadsheets. “Create, edit, and collaborate wherever you are“ as they said. Sometimes there is a need to visualize the data from the created spreadsheet. That’s why we implemented the way to do this task right inside Vizydrop. I am going to show how simple it is in this article.

1. Connect Google Account

First of all, connect your Google account to Vizydrop. Follow the following steps:

  • Start creating a new chart
  • Select Google Sheets in apps gallery
  • Proceed with the connection of the account by clicking the “Connect” button
  • Allow Vizydrop to connect to your spreadsheets in the authorization popup

2. Configure source

That’s a simple one. After connecting your Google account you will see a form of spreadsheet configuration. Select the desired spreadsheet and worksheet you would like to visualize. I am going to use stocks data set. You may find it here.

3. Configure the chart

Now the most interesting part of the process. It is a chart configuration. Drag and drop. Provide necessary calculations for dimension. It is all up to you.

You may try our platform at https://vizydrop.com or https://trello.vizydrop.com

The answer is 225.

--

--