Basic Chart
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives