How do I create a chart....

[Guest]

I would like to create a chart that counts the exact number of a specific
name compared to other names. The names are in the same column but each cell
may contains a differnt name and I would like to count how many times each
name appears in the column and then compare them in a graph.

 

[Guest]

try selecting the column (A)?
<data><Filter><advanced filter>
select unique values
select a cell for the data to start (C1)
hit enter
inD1 enter
=countif(A:A,C1)
hit enter and copy down to the end of the C Column.