Adding data to a chart

Adding data to your chart is a breeze. Each chart comes pre-populated with placeholder data to show how your indicators should be formatted when inserted into the chart. You can enter your data manually, copy-paste them, upload spreadsheets, as well as add the indicators from external sources.

Add data manually or by copy-pasting

  1. To add a chart to the canvas, click Add chart in the left-side toolbar and select the chart you wish to use. Drag-and-drop the chart onto the canvas.

    Adding_a_chart_.jpg

  2. Go to the Edit data tab in the Settings panel on the right or double-click the chart to access its data table.
  3. Click on a cell and start typing or use keyboard controls to copy-paste:

    Use Cmd + C to copy

    Use Cmd + V to paste

    Use Cmd + X to cut

    Use Cmd + Z to undo the last edit

    Use Ctrl + C to copy

    Use Ctrl + V to paste

    Use Ctrl + X to cut

    Use Ctrl + Z to undo the last edit

  4. Right-click a cell to access a menu with styling options:

    Cell_styling.jpg

 
Note: To access the option to Add/change link, you need to have a Business subscription or higher. 

Import data into your chart

You can also import data into charts from your computer, Google Drive, Dropbox, or several databases. Infogram supports the following formats: .xls (.xlsx), .csv, Google Sheets, JSON, and databases (MySQL, PostgreSQL, Amazon Redshift, Oracle, Microsoft SQL).

 
Note: Infogram doesn't support formulas, only raw data. If you import data from Excel, make sure it has only plain data in the cells, as the formulas won't work on Infogram.
  1. Go to the Edit data tab in the Settings panel on the right or double-click the chart to access its data table.
  2. Use one of the file import buttons above the data table.

You will need to authorize Infogram's access to some of your external data sources (Google Drive, JSON, databases), where a connection needs to be created for live updates. Read more in the article about creating live-updating charts and maps. All other sources (your computer and Dropbox) will only allow importing files. Each time you'll want to do an update, you will have to re-upload the file into your chart.

Import_data_options.jpg

 
Pro tip: Use the data formatting option just above the chart's data table to choose the decimal separator type your chart's data table will contain. This setting applies only to decimals, not thousands and millions.

Input_data_separator_type_decimals.jpg

For more on database integrations, read the article about using integrations in projects.