How To Add Data To a Chart

 

If you already have data to show, but are not sure which chart type to choose, please, take a look at this guide. Basically 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.

insert data

 

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.

insert data

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. Find the shortcuts at the top of the window. Keep in mind that 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.

insert data

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 updates your data at chosen intervals. Note that data in the chart is updated at specific intervals once it is published, viewed in preview mode, on the web or embedded. It may take more time for them to display the latest information inside the editor view.

insert data

Infogram chart interactivity is great for driving user engagement. One way of adding interactivity is by using tabs for data series. Tabs allow you to summarize two charts in one, making it easier for the reader to compare and contrast information.

To add tabs, insert a new sheet by clicking the ”+” icon on the bottom left corner of the editor, and add data to the new sheet.

insert data

For certain chart types, you can simply add a column in the same sheet to create an additional tab. Looking at the dummy data in each chart will help you understand how to structure your data.

insert data

To manage the sheets, click on the ”^” icon. You can delete the sheet, clear all data, duplicate it, give it a new name, or move it to a new position.

insert data

General rule of thumb: add data according to the example given.

Now it’s your turn!

Make a chart now