+ Reply to Thread
Results 1 to 8 of 8

Create Tag Cloud In VBA Possible?

Hybrid View

  1. #1
    Registered User
    Join Date
    10-26-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Create Tag Cloud In VBA Possible?

    Does anyone know a way to control where the table of unique words and their frequencies appear? I have a worksheet with multiple 10-15+ columns of qualitative info I'd love to be able to summarize any column using these codes (CreateUniqueWords as well as Chandoo's tag cloud generation code).

    I believe it would be best if it would be possible to output the table of unique words to another worksheet then create the tagcloud based off of the table and place it on this sheet. Basically I just want to keep my analysis separate from the worksheet with the original data.

    I'll be honest I had a little trouble following the following portion of the CreateUniqueWords macro. Thanks a bunch in advance!

    For Each rngCell In rngData.Cells
    For Each vntWord In Split(Replace(Replace(Replace(rngCell.Value, """", ""), "]", ""), "[", ""), " ")
    colWords.Add colWords.Count + 1, vntWord
    With Cells(29 + colWords(vntWord), 3)
    .Value = vntWord
    .Offset(0, 1) = .Offset(0, 1) + 1
    End With
    Next
    Next

    With Range("C30", Cells(Rows.Count, 3).End(xlUp)).Resize(, 2)
    .Sort .Cells(1, 2), xlDescending
    End With

  2. #2
    Registered User
    Join Date
    08-09-2011
    Location
    london,england
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Create Tag Cloud In VBA Possible?

    Heres a spin on tag clouds in excel, where you can set up a list of noise words, and set a threshold of how many occurrences are needed before it is included.
    http://ramblings.mcpher.com/Home/exc.../json/tagcloud

    I use similar code to quickly sum up groups of emails in outlook
    http://ramblings.mcpher.com/Home/exc...son/tagoutlook

    Finally, it uses a heatmap color ramp To colorise the results
    http://ramblings.mcpher.com/Home/exc...map/rampcharts


    Bruce

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1