+ Reply to Thread
Results 1 to 6 of 6

Tag clouds using free-form text entry (single column)

  1. #1
    Registered User
    Join Date
    12-06-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Tag clouds using free-form text entry (single column)

    I've been searching for a method of implementing tag clouds (word clouds, etc.) in Excel for over a year now (albeit off/on). I came across this post here (LINK) and feel it comes the closest to the results I am after.

    However, I may need something a bit more custom than this.

    Namely, I want to take the text in every row under one column (a free-form text entry field that is used to describe the nature of an incoming request for test automation) and then create a word cloud.


    What I have
    I have 3 sheets: Dashboard, Requests, Data.

    - "Dashboard" is intended to house all of my data visualization (charts, graphs, cloud, etc.)
    - "Requests" is intended to house all of my tracking for incoming automation requests (cost projection, a description of the request itself, etc.)
    - "Data" is intended to house data manipulated elsewhere in the sheet (hourly rates per department, items that appear in lists, etc.)

    What I need
    I want to...
    1. Take the "description" column on the "Requests" sheet
    2. Manipulate that data in some way (ideally on the "Data" sheet)
    3. Present that data in a word/tag cloud on the "Dashboard" sheet.

    I have followed Chandoo's examples and others several times over but nothing gets quite close enough to what I have been after... until now!

    Any thoughts?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Tag clouds using free-form text entry (single column)

    Not seeing why the examples you have cited are not addresses your needs other than sheet names and cell ranges.

    Can you post example workbook to illustrate your problem?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Tag clouds using free-form text entry (single column)

    If it helps I made this for something similar, you'll need to add a web browser control to your sheet and update accordingly.

    If you have a look, there are some really good jquery/google visualisations out there that you can adapt

    Please Login or Register  to view this content.

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

    Re: Tag clouds using free-form text entry (single column)

    Kyle123,

    Had sent you some messages but figured I'd ask here in case my questions can also benefit someone else. Thank you so much for posting your code.

    I've put the WebBrowser control on a seperate sheet named "Cloud," and changed the one reference within the WordCloud subroutine to the WebBrowser accordingly. I am trying to tweak the small bit of code that runs WordCloud to run off whatever range of cells are currently selected rather than statically referencing A1:A50 or the like.

    Please Login or Register  to view this content.
    Last edited by arthurbr; 12-08-2011 at 01:22 PM. Reason: Changed quote tags to code tags

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Tag clouds using free-form text entry (single column)

    VT,
    I just changed the tags you added from quotes to code. You need to use the #symbol in the Advanced editing to add these.

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

    Re: Tag clouds using free-form text entry (single column)

    Here is how to create a tag cloud from any excel range.

    http://ramblings.mcpher.com/Home/exc.../json/tagcloud

    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