Basic Chart
Options
Neil Brady
✭✭
I'm trying to create a chart that counts the number of entries in a particular column. eg a column which lists employee names. How do i produce a chart which tells me how many rows that name appears in?
Thanks in advance for any tips
Comments
-
You would need to create a table somewhere that has all of the names listed.
NAME COUNT
John Doe f
Jane Smith f
Eric Clapton f
Donald Duck f
Betty White f
.
Where you see "f", you would use a formula similar to this...
=COUNTIFS([Original Name Column]:[Original Name Column], Name@row)
.
This will give you the count for each name. You would then build your chart off of this table.