Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet.
More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart that shows the percentage of IT issues that were email related, hardware related, software related, etc.).
What do I need to do to get the percentage of each activity total for the column in order to create this chart in a dashboard?
Comments
-
You would just need to list out each type and use a COUNTIFS statement to keep a count for each one. From there you would use that data to create the pie chart, and the pie charts automatically default to a percentage.