Thread: How to make a chart from a list of names?

If I only hava a long list of names e.g like this;

Andy
Andy
Carol
Carol
Carol
Robert
Robert
Robert
Robert
and so on

I want to make a chart that shows both the names and how many times
the name are occuring in the list.

How can I do this with just a long list of names in Excel?

Thanks
/Chris

Chris -

You could make a pivot table from the list of names, putting the Name field
into the Row area and also into the Data area. This will provide a list with
each name occurring once and next to it a count of occurrences.

You could also use the FREQUENCY() worksheet function to achieve a list of
names and occurrences.

Then it is a simple matter to make a chart to display this data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Chris" <Chris@discussions.microsoft.com> wrote in message
news:9B389464-F4C3-4BC8-896A-FE73A71131D5@microsoft.com...
> If I only hava a long list of names e.g like this;
>
> Andy
> Andy
> Carol
> Carol
> Carol
> Robert
> Robert
> Robert
> Robert
> and so on
>
> I want to make a chart that shows both the names and how many times
> the name are occuring in the list.
>
> How can I do this with just a long list of names in Excel?
>
> Thanks
> /Chris

It was pointed out to me that FREQUENCY only works with numerical values.
Instead, you could use COUNTIF().

I would use the pivot table approach anyway. If you've never learned about
Pivot Tables, this would be a rather simple example to learn on. I have some
information and lots of links about pivot tables here:

http://peltiertech.com/Excel/Pivots/pivottables.htm
http://peltiertech.com/Excel/Pivots/pivotlinks.htm

Sorry if I caused any confusion.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Jon Peltier" <jonxlmvpREMOVE@CAPSpeltiertech.com> wrote in message
news:OtsUVl$AGHA.3872@TK2MSFTNGP12.phx.gbl...
> Chris -
>
> You could make a pivot table from the list of names, putting the Name
> field into the Row area and also into the Data area. This will provide a
> list with each name occurring once and next to it a count of occurrences.
>
> You could also use the FREQUENCY() worksheet function to achieve a list of
> names and occurrences.
>
> Then it is a simple matter to make a chart to display this data.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:9B389464-F4C3-4BC8-896A-FE73A71131D5@microsoft.com...
>> If I only hava a long list of names e.g like this;
>>
>> Andy
>> Andy
>> Carol
>> Carol
>> Carol
>> Robert
>> Robert
>> Robert
>> Robert
>> and so on
>>
>> I want to make a chart that shows both the names and how many times
>> the name are occuring in the list.
>>
>> How can I do this with just a long list of names in Excel?
>>
>> Thanks
>> /Chris
>
>