How can I generate a Tag Cloud of words in Excel?

A

Alex S.

Does anyone know of a plug-in or method to use Excel to generate a 'Tag
Cloud' chart / graphic in Excel?

I export database records to Excel for detailed analysis using pivot tables,
and I'd love to have a way to turn entries in a 'Keyword' field into a tag
cloud. Basically this:
- Read the contents of a column (field) marked Keyword, in a spreadsheet,
where each cell can contain more than one keyword
- generate a list of all unique key words (strings) that appear in the cells
- count how many times each unique keyword appears in the field
- create a graphic that shows all the keywords, with font sizes increasing
with increasing frequency of occurrence in the spreadsheet.

I believe that this would be a handy tool for generating graphics for
discussions, reports, etc.
 

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

How can I collect a list of tags from a document and build a list ofthem for filling a ComboBox from 0
simulate tag clound in word doc with VBA 4
Requesting help to generate progress reports in Excel ... 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Is a query on a word in a memo field possible ? 11
How to determine Last row of a Page in Excel 7
How do I generate an <xsl:foreach> tag in InfoPath? 0
How can excel generate every unique pair from a set of numbers? 3

Top