![]() |
How do I create a chart....
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. "awright" wrote: 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. |
All times are GMT +1. The time now is 11:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com