Add and manage your chart data
After preparing your data, add it to your chart to uncover trends, patterns, and relationships. You can input data manually, import it from a file, or connect it through supported data apps.
Add chart data manually
Enter your data into the chart table, then review each part of the chart to make sure it accurately reflects the data in your table
Add data
- Select your chart, then click Edit on the toolbar.
- In the side panel, enter your chart values in the Data table. You can also select Expand data table for a full-screen view of your data.
Add rows and columns
- To add a new row, choose a row, then click (More).
- Choose between Insert row before or Insert row after.
- To remove a row, choose Delete row.
- To add a new column, choose a column, then click (More).
- Choose between Insert column before or Insert column after.
- To remove a column, choose Delete column.
Note: When editing data on Canva, use the Shift key on your keyboard to select multiple cells, rows, and columns. You can also click and drag to select multiple cells.
Sort data
- To sort your chart data, select a column, then click on (More).
- Click Sort table A-Z to sort in ascending order, or click Sort table Z-A to sort in descending order.
Import chart data
Connect to data from Canva Sheets or connect to a data source app. You can also use a CSV, TSV, or XLSX file to import your data. For now, you can only import up to 1000 rows and 100 columns of data.
- Select or add a chart, then select Edit.
- From the side panel, click Import data.
- From here, you can choose to:
- Select Sheets to connect to data from Canva Sheets.
- Select a data source from the available options: Google Sheets, Salesforce, Google Analytics, HubSpot, World Bank.
- Upload a CSV, XLSX, or TSV file by selecting Upload data.
Tip: After your data loads, you can use Data Actions to clean and organise it before importing. See Clean imported data with Data Actions below.
4. If you chose a third-party app, sign in to the app (if required) and grant Canva permission to access your data.
5. Choose the specific dataset you want to use from the imported data.
6. Click Done to sync the data with your chart.
Cite the source of your chart's data
You can cite external sources to keep your information transparent and credible.
- Click on your chart to open the floating toolbar, then select Edit.
- In the side panel, go to the Customise tab.
- Click the Text dropdown.
- Under Source, enter the source name.
- Then, add the URL link to reference the website where the data came from.
Format chart data
Raw numbers can be hard to interpret at a glance. In Canva, you can format your chart data to make it easier to read—whether you’re working with currency, percentages, or long decimal values. Learn more about formatting chart data.
Was this helpful?
Helpful
Unhelpful