Canva home
Help

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

  1. Select your chart, then click
    Edit on the toolbar.
  2. 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

  1. To add a new row, choose a row, then click
    (More).
    1. Choose between Insert row before or Insert row after.
    2. To remove a row, choose Delete row.
  2. To add a new column, choose a column, then click
    (More).
    1. Choose between Insert column before or Insert column after.
    2. 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

  1. To sort your chart data, select a column, then click on
    (More).
  2. 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.

  1. Select or add a chart, then select
    Edit.
  2. From the side panel, click
    Import data.
  3. From here, you can choose to:
    1. Select Sheets to connect to data from Canva Sheets.
    2. Select a data source from the available options: Google Sheets, Salesforce, Google Analytics, HubSpot, World Bank.
    3. 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.

  1. Click on your chart to open the floating toolbar, then select
    Edit.
  2. In the side panel, go to the Customise tab.
  3. Click the
    Text dropdown.
  4. Under Source, enter the source name.
  5. 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

People also viewed