How to create a spreadsheet chart in Canva Sheets

We have data tables in Canva Sheets, and from there we can quickly create charts. Canva offers many chart templates based on data types, allowing you to choose the most suitable chart to insert directly into your spreadsheet. Below is a guide on creating charts from Canva Sheets data.

 

Guide to creating spreadsheet charts in Canva Sheets

Step 1:

In Canva Sheets, users create a new data table or use an existing one . Then, they select the entire data table for which they want to create a chart.

 

Step 2:

On the left-hand column of the interface, click on the Charts option as shown below.

 

Step 3:

You will immediately see chart templates based on the data in the table you selected. Click View all charts to expand the chart types.

You can view each chart type and then click on the chart that best suits the data you have in Canva Sheets.

 

Alternatively, you can click on the Actions section to select Magic Chart and create a chart directly from Canva AI.

Now we can add this chart to a new worksheet in Canva Sheets, or click on the chart to insert it into the current worksheet.

Step 4:

After inserting the chart, there will be an editing section on the left side. We can use these sections to modify the chart to our liking.