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
-
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.
- Go to the Edit data tab in the Settings panel on the right or double-click the chart to access its data table.
-
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
-
Right-click a cell to access a menu with styling options:
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).
- Go to the Edit data tab in the Settings panel on the right or double-click the chart to access its data table.
- 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.
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.
For more on database integrations, read the article about using integrations in projects.