Unable to select data range for a dashboard chart
In the Training it instructs you to select the data you need for your chart from a report. I am not able to do this - does anyone know why?
Training:
What i see: (Data greyed out)
Best Answer
-
Hi @helpaccount
You can use either cells in a Sheet or an entire Report as the source for your Chart Widget.
In the first image, the selection is made out of specific cells in a Sheet. In your screen capture, i can see that this is a Report type of Smartsheet item. See the sentence at the top which says this "will be charted in its entirety".
Reports are really useful as a Source because as new rows are added to the Report, this will automatically update your Chart. However you'll need to use the Filter in the Report to ensure that only the rows you want in the Chart are in the Source. Let me know if this makes sense or if I can help clarify anything further!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @helpaccount
You can use either cells in a Sheet or an entire Report as the source for your Chart Widget.
In the first image, the selection is made out of specific cells in a Sheet. In your screen capture, i can see that this is a Report type of Smartsheet item. See the sentence at the top which says this "will be charted in its entirety".
Reports are really useful as a Source because as new rows are added to the Report, this will automatically update your Chart. However you'll need to use the Filter in the Report to ensure that only the rows you want in the Chart are in the Source. Let me know if this makes sense or if I can help clarify anything further!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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