Display Pie Chart in a Dashboard

1996mustang

SS Capture 5-24.PNG

Uploaded May 24, 20229.07 KB

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

Christian Graf

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

Christian Graf

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

1996mustang

Yes, that worked. Thank you.