Display Pie Chart in a Dashboard
I have a sheet that is linked to another sheet that counts how many RED, YELLOW, GREEN, and BLUE dots. My problem is when I try to make a Pie chart from this data in a Dashboard, the Pie chart icon is greyed-out and not available?
Thoughts?
ds
Best Answer
-
Hello @1996mustang
This is typically a problem when you have more information on a sheet than just numeric values, and text to describe those values. If you create a report from that sheet with the first column as the information label, and the second column as your numeric count, you should be able to create a pie chart from the report.
Hope this helps! Thanks
Answers
-
Hello @1996mustang
This is typically a problem when you have more information on a sheet than just numeric values, and text to describe those values. If you create a report from that sheet with the first column as the information label, and the second column as your numeric count, you should be able to create a pie chart from the report.
Hope this helps! Thanks
-
Yes, that worked. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!