Infogram offers you creating live-updating charts - if you import data into your chart from Google Spreadsheet or self-hosted JSON data source, as soon as you will change data inside these data sources, the changes will be automatically updated also in your Infogram chart, even where embedded.
1. Prepare your data source
The first step to setting up live updates in a chart is gather data in a Google Sheet. Or if you plan to create a JSON data base - here's formatting example how your JSON should look like: https://infogram.com/api/examples/live.json
2. Create a chart on Infogram
Once you have prepared your data, head to Infogram and create a chart. Select the chart type that best fits the information you want to display. If you're not sure, try adding any chart type to your project and double-click it to see our example data - you need to keep the same column/row layout also in your google spreadsheet for the chart to work correctly.
Also, keep in mind that most infogram charts can only display numeric data (line, column, bar, pie, bubble charts etc.), however there are some that are designed to show especially textual information (word cloud, treemap), so if your data source has some columns as numbers and some as text, you either need to separate textual ones and visualize them in a separate text-based chart or you can import it all in a Table chart which supports numbers + text inside one table.
Notice the buttons above the data table. There you can connect a Google Spreadsheet or a JSON data source to a chart.
3. Connect to your Google account
The first time you will try to import data from a Google Spreadsheet, you’ll need to connect to your Google account to grant access to your sheet. Just log in with your account and authorize access.
4. Select spreadsheet
Choose the spreadsheet with the data you need from your Google Drive, and click “select”.
If your spreadsheet has several sheets, pick the sheet you want to show or select all sheets if you want to show multiple information in the same chart (this will create tabs).
Note: If your Google spreadsheet contains multiple sheets, the connected one is indexed by the sheet order number. This means you should avoid adding additional sheets in between the document, as this might change the order of sheets and the data the charts connect to.
Now all you need to do is publish your infographic (live update works also with privately shared charts), and as soon as you will change info in your Google Spreadsheet, it will also automatically update in your Infogram chart and adjust the visualization, even if the chart is embedded inside your web page!
Note: it could take up to 1 minute for the data to refresh.
When you connect a spreadsheet, you are unable to edit the data, howe, er you can change other chart options. Specify the colors, add information explaining what the X and Y axes are with labels, define ranges and format numbers.
That's it! Now you can share your chart and never worry about changing it again! You can just update the information in the Google Spreadsheet connected to the chart and see the chart automatically update upon loading!