Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to make a chart from a list of names?
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to make a chart from a list of names?
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 he 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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) | |||
List of repeating names | Excel Worksheet Functions | |||
How do I print a list of worksheet tab names in a workbook | Excel Worksheet Functions | |||
List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions |