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 information? 👀 | 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 information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives