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
Check out the Formula Handbook template!