how do i make a graph from text ?

J

Jan Derksen

I have made a database in wich I want to count the amount of words that apair
in a collum
 
J

Jon Peltier

Jan -

You can make a pivot table that will count the number of occurrences of each item in
the list, then make a histogram (column chart) of the pivot table.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help making graph 3
Dynamic graph 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
graph creation from table using cells with links not possible 0
Getting the graph style I want 4
How to make repeating drop-down lists? 2
Graph Line Width ? 1
Overlay line graph points on bar graph 1

Top