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?