Word cloud generator application based

[kuldeepjainesl]

Hi All,


Is there any application around which can create offline word cloud. As of now I am using chandoo technique from http://chandoo.org/wp/2008/04/22/create-cool-tag-clouds-in-excel-using-vba/


But I need a bit colourful tag cloud one like available at http://www.clearlyandsimply.com/files/2010/11/tag_clouds_using_wordle.xls


http://www.clearlyandsimply.com/clearly_and_simply/2010/11/wordle-tag-clouds-in-microsoft-excel.html


But i need a offline solution. Any suggestion...


Regards

 

[Hui]

KPJ


One easy method is to rank your data using a ranking formula, lets say you want the top 10

Then add Ten Text Boxes

Link each text Box to cells with ranks 1 to 10

Arrange to suit


As you re-rank the data or sort etc your word cloud will change

 

[kuldeepjainesl]

Thanks Hui,


But i could not get it in full. Making text box and linking them to data is OK but re-rank is not clear to me.


Actually i have a list of top 20 Words which i generated by countif.


Data is Like

[pre]

A       254
B       235
C       124
D       97
E       53

[/pre]

etc. A bit of more guidance is needed me to accomplish this. If i may get the modified code of VBA that will also work for me or a guidance to modify the code.


Regards,

 

[Faseeh]

Hi KPJ,


This explains what Hui said:


http://dl.dropbox.com/u/60644346/ArtificialWordCloud.xlsx


Regards,

 

[Hui]

or have a look here: http://chandoo.org/wp/2008/04/22/create-cool-tag-clouds-in-excel-using-vba/

 

[kuldeepjainesl]

Thanks Faseeh,


Now I understand. is this the same you used in your inventory dashboard few time back?


@Hui : This is the technique i am using already but wanted to add colour in to this along with orientation.


Thanks,

 

[Faseeh]

Yes KPJ, it is the same technique. But tends to be hectic if you have huge data and the task is repetitive, if it is once only activity you can do it. Other wise use the VBA Code.

 

[kuldeepjainesl]

Yes, i agree


I will need to generate around 10 clouds every month. As of now i am using chandoo VBA code but want to get something which can add colour to it based on size of text.


Edit : Finally i could found a application that seems to do this job. Here is the link http://www.mosaizer.com/Wordaizer/index.htm even with many more features. Starting to exploring it so though to share it before.


Experts review are welcome.


Regards,