Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Excel 2007 PivotTable
Various graphics of keywords frequency. http://www.mediafire.com/file/2hwmji...12_23_09b.xlsx |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Excel 2007 PivotTable
If a cells contains several keywords, use this method to graph occurrence count. http://c0444202.cdn.cloudfiles.racks...12_23_09b.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
draw revision cloud | Excel Discussion (Misc queries) | |||
Generate a password ffom 4 words | Excel Discussion (Misc queries) | |||
How can I cloud mark on an excel sheet? | Excel Discussion (Misc queries) | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) |