The previous two posts (Word Clouds with Microsoft Excel and The Implementation of Word Clouds with Excel) provided and explained my VBA-based solution to create dynamic Word Clouds (aka Tag Clouds) in Microsoft Excel.
How to create Word Clouds with Tableau and a look at the value of Word Clouds for serious Business Data Analysis
I will go into the details of my approach in a follow-up post.
Today’s article introduces my new implementation of word clouds in Excel including the workbook(s) for free download. Moreover, realizing a word cloud in Excel is an interesting VBA challenge.
However, they definitely have their place in infographics. I am fully aware of the fact that word clouds are a very poor tool for data analysis and business data visualizations. a visual representation of text data where the font size of a word depicts the frequency of this word in a text. Microsoft Excel provides no native feature to create a word cloud (aka tag cloud), i.e. Tuesday, FebruRobert at 09:00 PM in Charts, Dashboards, VisualizationĬreate dynamic Word Clouds / Tag Clouds in Microsoft Excel As always, the article includes the Excel example workbook for free download.
Today’s post shows a way how to include Wordle tag clouds into your Excel workbook, dynamically based on texts in any cell ranges. Who dared to think he would do this without providing a dashboard? Of course he did. One week back, my friend and Excel MVP Chandoo published a post to celebrate the very impressive milestone of the 10,000th comment on his blog: 10k Comments Excel Dashboard. Tuesday, NovemRobert at 11:00 PM in Microsoft ExcelĬreate dynamic Tag Clouds in Microsoft Excel using advanced Wordle Word cloud- Wordle Tag Clouds in Microsoft Excel Of course the tool is provided for free download. the data structure needed for the word cloud workaround. Today’s follow-up article will have a closer look into the machine room: some more details on the approach, the data structure, the algorithm, the implementation in VBA and a dirty little trick to optimize the performance of the code for inserting and formatting freeform shapes on a worksheet using VBA.Īs a little bonus, today’s post also includes a tiny Excel tool to easily split continuous texts into a list of words and their count, i.e. Robert at 03:00 PM in Charts, Dashboards, Microsoft Excel, VisualizationĪpproach, algorithm, VBA code and performance optimization of the Word Cloud with Excel implementation Word cloud- The Implementation of Word Clouds with Excel And remember, don't look a gift horse (or word cloud) in the mouth! Download his sample file, and try it out.
Robert Mundigl shows how to create word clouds in Excel, an update from his earlier method. It works by using combinations of font sizes and colors to arrange a group of words into an image which can then be used to illustrate a website, letterhead, signature, logo, homework, whatever. Word clouds are a fun and innovative way to transform a collection of ordinary words into an illustration. Word Cloud- Create Customized Word Cloud Art for Free – Tagul Online. Mostly PC, but maybe you can one or more of them that also have a Mac verison Here are some links about word cloud tools.