Approach, algorithm, VBA code and performance optimization of the Word Cloud with Excel implementation
The previous post Word Clouds with Microsoft Excel introduced another workaround to create a word or tag cloud in a standalone Microsoft Excel workbook.
The article briefly describes the approach, the user-defined settings, the result and the drawbacks of the workaround. It also provides 3 different versions of the workbook for free download.
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.
As 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. the data structure needed for the word cloud workaround. Of course the tool is provided for free download.