How do I create a chart....

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top