Build a Canva chart that updates when your figures change

A weekly report often needs a rate as well as a count. Sixteen bookings from 80 visits tells a different story from sixteen bookings from 800. A small spreadsheet can preserve that relationship and supply the figures for a chart that remains useful when the next correction arrives.

This walkthrough follows Canva’s documentation, checked on 28 October. The practice data and prompt are original, and the arithmetic was independently checked. We have not run the exercise in a signed-in Canva account.

Use an account with Magic Formulas available. Canva’s current usage guidance classifies it as a Standard AI tool; allowances depend on the plan. Check your account under Settings → Billing → AI usage before starting.[3]

Put the rate beside the week

From Canva’s home page, choose Sheets and start a blank sheet. You can enter the values directly into cells.[4]

In row 1, put Week in A1, Bookings per 100 visits in B1, Visits in C1 and Bookings in D1. Leave B2:B4 empty for the calculation. The unusual column order keeps the two chart columns beside each other.

Select B2, type = and choose Magic Formulas from the suggestions. Describe the calculation, then choose Insert to apply the generated formula.[1]

For this example, =D2/C2*100 gives 10. A different expression is acceptable if it preserves the same relationship. A formula that returns 12 has copied the booking count; one that returns 0.1 has omitted the multiplication needed for the chosen unit. Neither matches the column heading.

Inspect the formula’s cell references; the ? control can explain the generated function. Canva’s suggested repairs address syntax problems, so a formula that runs still needs to express the calculation you intended.[1]

For the remaining practice rows, enter =D3/C3*100 in B3 and =D4/C4*100 in B4. The three rates should now be 10, 20 and 5. Keep them as ordinary numbers: the heading already states the unit. These are rates per 100 visits, not additional bookings.

Connect the chart to those cells

Select A1:B4, including the headings. Choose Actions → Magic Charts and select a bar chart from the side panel. Canva documents automatic updates from the linked source. Select the chart, choose Edit and inspect its Chart Source information to confirm the sheet and range.[2]

The finished chart should contain three weeks and one rate series. Week 2 should have the longest bar, Week 3 the shortest. Week 1 has only two more bookings than Week 3, but twice its booking rate. The denominator changes the size of the difference.

Change D4 from 10 to 20. B4 should become 10, making Week 3’s bar match Week 1’s. Week 2 should remain at 20. This one change checks the whole path from an input count through the formula to the displayed comparison.

If B4 changes but the chart does not, inspect Chart Source. Its menu provides Edit Data Source and Open Linked Source. Disconnect from Source removes the updating link, so retain that connection for this exercise.[2]

Keep a live report live

Magic Insights is a separate route with different behaviour. Canva says its charts use a copy of the data, which may be grouped or rearranged. Changes to the original sheet do not automatically update those charts; the insights must be generated again. That distinction matters when choosing a chart for recurring reporting.[5]

Give the design a recognisable name, such as Weekly booking rates — practice. Canva autosaves progress. Keep the sheet and linked chart together in the same design, where Canva documents their live connection.[4]

Before replacing the example with real figures, agree what a visit and a booking mean. Use the same reporting period for both, and resolve any week with zero visits before dividing. The useful result is a report whose unit, calculation and update behaviour you can explain when someone asks what changed.

Report an error or suggest a correction