Using entire columns to create dashboards in lieu of cells
I am tryin to create a dashboard that tracks a trend over time (weeks). It is pulling from a sheet where we document production week to week. I'd like to create a dashboard that will pull from the entire columns so that when I add future data it will automatically pull into the dashboard.
So far it seems that I have to manually select the cells I want to pull data from.
Is setting column as a data source for a dashboard possible?
Answers
-
Hi @Luis Perez
You can use a Report as a source for a Chart!
When a Report is selected as a source, the entirety of the content is used in the Chart (you cannot select specific cells). This means that as new rows are added to the sheet they will automatically appear in the Report, which will then automatically update the Chart.
See: Using Chart Widgets
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!