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

Paul Newcome

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.