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?



Best Answer

  • Christian Graf
    Christian Graf ✭✭✭✭✭
    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!