Prev: Changing Pivot Table Data Source to multiple ranges
Next: text box
From: Alex S. Alex S. on 23 Dec 2009 13:45
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.
From: Herbert Seidenberg on 23 Dec 2009 15:18
Excel 2007 PivotTable
Various graphics of keywords frequency.
http://www.mediafire.com/file/2hwmjiznloz/12_23_09b.xlsx
From: Herbert Seidenberg on 23 Dec 2009 17:40
Excel 2007 PivotTable
If a cells contains several keywords,
use this method to graph occurrence count.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_23_09b.xlsx
 | 
Pages: 1
Prev: Changing Pivot Table Data Source to multiple ranges
Next: text box