There are some charts that can visualise only numbers (like pie, bar, area charts etc.) and there are some which allow you to show also non-numerical data (maps, facts&figures, word cloud, not to mention the various text fields). Once you’ve chosen the right option for your data and added a chart to your project, click once on the chart to access chart settings in the right side panel of your screen. Double click on the chart to access the chart’s data table in the same panel.
When you open the data table, you’ll see the chart editor pre-populated with dummy data. The data is there to help you understand how to structure your data for that particular chart type. You will always be able to preview the chart on the left, so you’ll know if the chart looks the way you want it to.
Like with Excel or Google Sheets, you can edit, cut, copy and paste the data by right-clicking with your mouse or using keyboard shortcuts Ctrl+C/Ctrl+V. There’s also a blue drop-down icon in each cell that opens the menu for editing options.
Apart from copy-pasting, you can also import data from external sources such as your computer hard drive (.csv and .xls formats) , Google Drive, Dropbox, OneDrive and a JSON feed. NOTE: the data in your imported xls file also has to be formatted according to the data format and layout used in your chosen chart’s dummy data, as you won’t be able to select what cells, rows or columns to import from one huge imported xls data sheet – the data has to be split in sheets and prepared accordingly before importing.
To import data from external sources, you must authorize the Infogram application. If you decide to disconnect Infogram’s access later, you can do so in the connected service settings.
If you’re using Infogram Premium plans, connecting a Google Sheet or JSON will allow you to establish a live-data connection which will automatically update your chart (even where embedded) as soon as the data inside the Google Spreadsheet or JSON will be changed.