Word Cloud ama Tag Cloud waa nooc ka mid ah garaafyada loo isticmaalo in lagu sawiro ereyada muhiimka ah iyo calaamadaha lagu isticmaalo xogta qoraalka. Waxa la soo saaray iyadoo lagu salaynayo soo noqnoqoshada iyo caannimada ereyada loo adeegsado qoraalka. Hagahan, waxaan ku wadaagi doonaa cashar ku saabsan sida loo abuuro daruur kelmad gudaha Microsoft Excel .

Kahor intaanan bilaabin, aan sheego in aysan jirin muuqaal asal ah oo MS Excel ah oo kuu ogolaanaya inaad abuurto daruur kelmad. Si kastaba ha ahaatee, waxaa jira qaar ka mid ah add-ons oo aad ku rakiban karto si aad u abuurto daruuraha tag, sida Bjorn's Word Clouds, ChartExpo , iwm. Laakiin, intooda badan waa lacag iyo kuwo kale waa tijaabo. Si aad ugu darto daruur kelmad gudaha Excel bilaash ah, waxaad u baahan doontaa inaad tijaabiso khiyaamo fudud oo aan ku wadaagi doono maqaalkan. Waxaan isticmaali doonaa adeeg dhaliyaha ereyga tooska ah ee bilaashka ah si aan uga abuuro daruur sumad xogta Excel ka dibna aan u soo geliyo Microsoft Excel . Aynu eegno adeegga shabakadda iyo tillaabooyinka sidaas loo sameeyo.

Sida loo abuuro Word Cloud gudaha Excel

Tallaabooyinka aasaasiga ah ee lagu daro erayga daruur gudaha Excel waa:

1. Ku samee xaashi shaqo gudaha Excel oo ku dhoofi qaabka XLSX .
2. Bilow biraawsarkaaga oo fur website WordClouds.com .
3. Soo dejinta loo sameeyay faylka Excel , soo saar daruur suug, habayso erayga daruur, oo u dhoofi faylka sawirka.
4. Aad Excel oo ku dar erayga kaydsan sawirka daruuraha xaashidaada.

Aynu si faahfaahsan uga wada hadalno tillaabooyinkan.

Marka hore, waxaad u baahan tahay inaad abuurto xaashida faafinta ama aad furto mid jira oo Excel ah, kaas oo aad rabto inaad abuurto daruur kelmad. Ka dib markaad ku darto xogtaada xaashida, ku keydi qaabka XLSX Excel adigoo isticmaalaya File > Save As option.

Hadda, fur biraawsarkaaga oo tag adeegga shabakadda ee loo yaqaan WordClouds.com . Adeegga shabakada wuxuu kuu ogolaanayaa inaad ka abuurto daruur kelmad dukumentiyada Microsoft Office, faylasha qoraalka,^{(Microsoft Office documents, text files,)} iyo PDFs .

Marka xigta, u gudub liiska Faylka^(File) oo guji ikhtiyaarka dukumeentiga Open MS Office si aad u soo dejiso faylka xaashida ee ^{(Open MS Office document )}Excel ee aad abuurtay.

Taas ka dib, waxay falanqeyn doontaa oo farsameyn doontaa xaashidaada XLSX waxayna ka dhalin doontaa daruur kelmad xogta Excel ee la soo dejiyay. ^(Excel)Waxaad markaas habayn kartaa cabbirro badan si aad u saxdo erayga daruur si waafaqsan.

Tusaale ahaan, waxa ay ku ogolanaysaa in aad beddesho^(change) cabbirka daruuraha kelmadda, in aad habayso cabbirka farqiga u dhexeeya erayada, dooro ^{(select a shape)}mawduuc, wax ka beddelka midabada, beddelka farta nooca iyo cabbirka, dooro jihada erayada,^{(word cloud size, customize gap size between words, select a theme, edit colors, change font type and size, choose direction of words, )} iwm. qaabab iyo xarfo kala duwan oo diyaar ah.

Waxa kale oo aad gacanta ku tafatir kartaa liiska kelmada^{( edit the word list)} laga keenay xogta Excel adiga oo gujinaya badhanka liiska Word . ^{(Word list)}Intaa waxaa dheer, waxay kuu oggolaaneysaa inaad soo dejiso liis kelmado gaar ah ama aad u dhoofiso liiska hadda jira faylka CSV .

Marka lagu sameeyo habaynta eraygaaga daruur, waxaad u soo dejisan kartaa si caadi ah ama HD sawirka JPG , PNG , ama qaabka SVG adigoo isticmaalaya File > Save as Image ikhtiyaarka sawirka.

Hadda mar kale u tag xaashida xaashida ee Microsoft Excel , oo laga bilaabo Gelida^(Insert) tab, guji Sawirada> Sawirada> Xulashada Illustrations > Pictures > This Device

Tani waxay kuu ogolaanaysaa inaad baadho oo aad soo dejiso erayga Cloud image oo aad hore u soo dejisay. Waxaa lagu dari doonaa xaashida Excel oo waxaad ku dhejin kartaa meel kasta oo xaashida faafinta ah. Intaa waxaa dheer, waxaad diyaarin kartaa, cabbiri kartaa, dalool kartaa, bedeli kartaa qaabka sawirka, ^{(arrange, resize, crop, change picture style,)}oo^(format) aad qaabayn kartaa garaafyada kalmadaha lagu daray.

Maqaalkani wuxuu ku tusayaa hab sahlan oo aad ku abuuri karto daruur kelmad xogta Excel ka dibna ku dar xaashida shaqada ee Excel adiga oo isticmaalaya adeeg online ah oo bilaash ah. Isku day oo ku dar daruuraha ku dheji xaashida shaqada ee Excel iyada oo aan dhib badan lahayn.

Akhri wax la xidhiidha: Ku ^{(Related Read:)} samee Word Cloud gudaha PowerPoint.^{(Create a Word Cloud in PowerPoint.)}

How to create a Word Cloud in Excel

Word Cloud or Tag Cloud is a kind of graph used to visualize important keywords and tags used in a text data. It is generated based on the frequency and prominence of words used in text. In this guide, I will be sharing a tutorial on how to create a word cloud in Microsoft Excel.

Before I start, let me mention that there is no native feature in MS Excel that lets you generate a word cloud. However, there are some add-ons that you can install to create tag clouds in it, like Bjorn’s Word Clouds, ChartExpo, etc. But, most of them are paid and others are trials. To add a word cloud in Excel for free, you will need to try a simple trick that I am going to share in this article. I will be using a free online word cloud generator service to create a tag cloud from Excel data and then import it into Microsoft Excel. Let’s checkout the web service and steps for doing so.

How to create Word Cloud in Excel

Basic steps to add a word cloud in Excel are:

1. Create a worksheet in Excel and export it in XLSX format.
2. Launch a web browser and open WordClouds.com website.
3. Import created Excel file to it, generate a tag cloud, customize the word cloud, and export it to an image file.
4. Go to Excel and add the saved word cloud image to your spreadsheet.

Let’s discuss these steps in detail.

Firstly, you need to create a spreadsheet or open an existing one in Excel, for which you want to generate a word cloud. After adding your data to the spreadsheet, save it in XLSX Excel format using the File > Save As option.

Now, open a web browser and go to this web service called WordClouds.com. This web service lets you create a word cloud from Microsoft Office documents, text files, and PDFs.

Next, go to the File menu and click on the Open MS Office document option to import the Excel spreadsheet file you created.

After that, it will analyze and process your XLSX spreadsheet and generate a word cloud from the imported Excel data. You can then customize a lot of parameters to edit the word cloud accordingly.

For example, it allows you to change word cloud size, customize gap size between words, select a theme, edit colors, change font type and size, choose direction of words, etc. It also lets you select a shape for the word cloud from various available shapes and letters.

You can also manually edit the word list fetched from Excel data by clicking on the Word list button. Additionally, it allows you to import a custom word list or export the current list to a CSV file.

When done with customizing your word cloud, you can download it as a normal or HD image in JPG, PNG, or SVG file format using its File > Save as Image options.

Now again go to the spreadsheet in Microsoft Excel, and from the Insert tab, click on Illustrations > Pictures > This Device option.

This will allow you to browse and import the word cloud image that you downloaded previously. It will be added to the Excel sheet and you can place it anywhere in the spreadsheet. Furthermore, you can arrange, resize, crop, change picture style, and format added word cloud graphic.

This article shows you an easy method to create a word cloud from Excel data and then add it to your Excel worksheet using a free online service. Try it and add tag clouds to Excel worksheets without much hassle.

Related Read: Create a Word Cloud in PowerPoint.

Related posts

• Sida loo abuuro Word Cloud gudaha Microsoft PowerPoint

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Kordhi tirada faylalka u dambeeyay ee Word, Excel, PowerPoint

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Ku hagaaji Saddex Xagalka Jaallaha ah oo leh Barta Dhawaaqa ee Excel ama Word

• Sida loo suurtageliyo Mode-madow ee Word, Excel iyo PowerPoint

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loogu daro Developer tab ee barnaamijyada Word iyo Excel Office

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Soo deji Word, Excel, PowerPoint, Access, Visio Templates oo bilaash ah

• Sida loo isticmaalo shaqada COOSE ee Excel