This test shows that we can create charts and tables in Google Sheets that we can show on the website.
The process for this is.
- Add the tabular data to a Google sheet
- Convert the data to a chart and format colours/layout
- Publish the chart
- Copy the embed code.
- Copy the embed code into a page in Umbraco.
Note: to update the data in the chart, just update the google sheet, and then save and publish the Umbraco page again.