ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a chart.... (https://www.excelbanter.com/charts-charting-excel/25111-how-do-i-create-chart.html)

awright

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.

bj

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