Vizzlo has an option to update charts automatically. This will save you a lot of time when the data source updates frequently and you want to avoid updating your charts manually. You can connect any chart to a public Microsoft Excel file, or a public Google Sheet.
These files can either be hosted 'anywhere' in the World Wide Web or in one of your cloud storage accounts, that you connected to your Vizzlo account.
Use case: Estimation of the current development of the SARS-CoV-2 epidemic in Germany
(The data for the chart is updated daily at 12pm)
In Germany, the Robert Koch Institute monitors public health and advises the federal government, e.g. on preventing and tackling infectious disease outbreaks such as the COVID-19 pandemic. Its core tasks include the detection, prevention and combating of infectious diseases and non-communicable diseases in Germany. On the institute's website it publishes data about new infections and the reproduction rate of the virus. The data is made available as an Excel file and updated daily (only in German unfortunately):
To create the chart above, you need
— to create a Time Series Graph (because the data is time based)
— open the spreadsheet
— In the right corner click on
Connect to open the Sync data dialog
You have two options:
- Link to a Google Sheet document or an Excel file hosted on the web or on a cloud storage provider, or
- You can now connect Vizzlo documents to Excel or Google spreadsheets stored in any supported Cloud storage…
…and schedule automated updates.
In this tutorial, we will take the 1. route and connect a time series graph to an Excel sheet. But either way, this will save you a lot of work when you get new data regularly and you want to avoid updating your charts manually.
Link to a Google Sheet document or an Excel file hosted on the web
The data we want to connect to the time series graph is called
Tabelle mit Nowcasting-Zahlen zur R-Schätzung
Right-click on the link and choose the option Copy link address.
It is the following link that will be now be copied to your clipboard, and we will then paste into the text input of the Sync data dialog.
That does not look like what we would have expected. That is because by default, the Vizzlo server assumes that the data is stored in the first workbook of a spreadsheet. Luckily there is an option to switch to another workbook. In this case there are only two, and we need to switch Nowcast_R.
Things to notice: When you connect a chart to external data source the existing columns names won't be overwritten. This has the advantage that when you change the names in your document, they stay the same even if the data is updated regularly. In the last animation you'll see the second column name is Series. This is simply the default of the Time Series graph.
The next steps are:
— Select a specific data range
— Schedule the updates
You have the option to only keep a selection of columns from the file. That is what the
We are almost there. In the sidebar, switch to the tab that say 2. Auto sync to schedule your updates. You can set the interval to hourly, daily, weekly. Once you are done, click the Okay button at the bottom right and your document will be in sync and you can style it as you need.
Connect Vizzlo documents to Excel or Google spreadsheets stored in your Box, Dropbox, Google Drive or One Drive
We saw how to connect a Vizzlo document to a public Excel file hosted on the web. The same can be applied to data you store in your cloud storage. For this there are two option
- Paste a public link to a Excel file or Google sheets document into the Sync data dialog
- Browse your files and connect from Vizzlo
How do I make my Google sheets document public in Google Drive?
— Go to drive.google.com
— Select the document that you want to make Public.
— Right click on the document and select Share option.
— Under “Get Link”, click the Down arrow
— From the dropdown menu, make sure to select the option Anyone with the link
— Copy the link and paste it into the Sync data dialog
Reach out to Google support for further info on sharing files, or leave us a message at firstname.lastname@example.org if you have difficulties.