I have built quite a few charts in Google Sheets that I want to embed on a webpage on my site. The charts update frequently, and I want those updates to auto refresh on the site without any manual intervention.
I have figure out how to technically get it done (click on Publish Chart -> Embed -> Copy Link to a Custom HTML Block In Elementor (the page builder I use)). But I’m a bit lost when it comes to optimizing the layout from there. Meaning, I want the chart to be responsive and scale appropriately with the screen/window size. And ideally I’d like to control the chart size in WordPress, not Google Sheets (or vice versa). Currently, it seems like I have to perfect the sizing twice, once in Sheets and again in the page builder container/embed block.
I also want to have a bunch of different charts on one page. Any ideas on layouts or a clean way to organize all of them so they are consistently sized and spaced?
Any tips or tricks would b appreciated!