What’s the easiest way to connect data and auto-update charts in a dashboard?

[AndrewFJ]

I’ve been trying to build a simple dashboard to track our weekly sales and project statuses, but I keep hitting a wall with the data connections. I’m using a spreadsheet for our raw numbers, but getting it to automatically update the charts feels way more complicated than it should. Is there a straightforward method for this that doesn’t require a ton of custom scripting?

[LaylaAT]

I tried this on a sprint last month. Put our raw numbers into an Excel table (the thing you turn into with Ctrl T). The charts were set to pull from that table, not a fixed range. When we added a new week, the table grew and the charts updated automatically. No scripts, just a stable data structure.

[DonaldAG]

In Sheets I kept everything on one sheet and built charts from those ranges. It updates as soon as I change the data. If you’re pulling weekly totals from multiple tabs, you can use IMPORTRANGE or roll everything into a summary sheet with a simple SUMIF.

[Elizabeth31]

Looker Studio can pull from Sheets and show a dashboard that auto refreshes. You connect the data source once and pick charts; then you can set a refresh interval. It took a bit to get the metrics aligned, but it worked after that.

[Layla.L]

One of my experiments drifted off topic for a bit; I was chasing a slick dashboard before fixing the data. We ended up splitting the data into weekly totals and project status on the same sheet and kept the charts simple. Still not sure if the problem is the connections or the data shape. Is the issue the data structure, or is the chart tool not connected at all?