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 help? 👀 | 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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!