Microsoft Excel waxay ku fiican tahay tirooyinka, hubaal, waxay si fiican u qabataa shaqadan. Laakiin, haddii aad raadinayso inaad u soo bandhigto xogtaada qaab soo jiidasho leh oo kuu ogolaanaya inaad si fudud u sawirto oo aad u falanqeyso, markaa alaabtan cajiibka ah ayaa laga yaabaa inay ka maqan tahay sifooyin. Tani waxay u baahan tahay xoogaa taageero ah - tijaabi Data Visualizer add-in for Excel.

Ku -darka Xogta Visualizer -ka ee ^{(Data Visualizer)}Excel waa cudud cusub oo Excel ah taas oo u beddeli karta xaashida shaqada ee Excel 365 jaantus Visio . Ku-darkaani wuxuu u oggolaanayaa dadka isticmaala inay si toos ah u abuuraan jaantusyo tayo sare leh, jaantusyo isku-dhafan, iyo jaantusyo urureed - dhammaan qaababka, isku xirka, iyo xogta isku xirka - laga bilaabo xogta ku jirta miisaska Excel . Isticmaalayaashu uma baahna inay iibsadaan Visio si ay u isticmaalaan Microsoft Visio Data Visualizer qaabkeeda fudud, kaliya Excel 365 ee Windows/Mac ama Online. Tani waa hal qalab oo xiiso leh oo mudan in la isku dayo haddii aad si joogto ah u sameyso jaantusyada socodka ama jaantusyada.

Waxa kaliya ee aad u baahan tahay si aad u bilowdo waa isdiiwaangelinta Office 365^{(Office 365)} — ku-darka ka- qaybgalka Visio^(Visio) Looma baahna^(NOT) .

Xogta Visualizer Add-In for Excel

Xogta Visualizer^{(Data Visualizer)} waxay ka faa'ideysataa sida ugu fiican ee Excel iyo Visio ; waxaad gelisaa xogta buug-shaqeedka Excel , Visio wuxuu si toos ah u abuuraa jaantus. Qof kasta oo haysta rukunka Xafiiska 365^{(Office 365)} wuxuu isticmaali karaa ku-darka Xogta Visualizer^{(Data Visualizer)} si uu u abuuro jaantusyo Visio ; Isticmaal xogta hoose ee Excel si aad u bedesho jaantusyada; iyo, arag, daabac, oo wadaag jaantusyada.

Qalabkani waa beddelka fursadaha jaantuska ee horeba u yaal Xafiiska^(Office) kaas oo bixiya xulashooyin xaddidan oo noqon kara mid aad looga xanaaqo.

Ku samee^{(Create Flowcharts)} jaantusyada socodka iyo jaantusyada^{(Organizational)} abaabulka gudaha Excel

Ku -darka Xogta Visualizer -ka ee ^{(Data Visualizer)}Excel ayaa diyaar u ah:

• Excel ee Windows
• Excelon Mac iyo
• Excel ee shabakada oo leh xisaab shaqo ama dugsi

Si aad ugu rakibto Data Visualizer mid ka mid ah kuwan kore, waa inaad raacdaa tillaabooyinkan:

1] Fur ' Excel' oo samee buug-hawleed ' Banaan' oo cusub^(Blank’)

2] Guji ' Insert' ka dibna ku dhufo ' hel Add-ins^{(Get Add-ins)} '

3] Gudaha Bakhaarka Add-ins Office^{(Office Add-ins Store)} , ka raadi 'Visio Data Visualizer ' oo ku dhufo badhanka ' Kudar '.^(Add)

4] Hadda 'Sign in' oo leh akoonkaaga la xidhiidha Office 365 subscription/Microsoft 365 work/ school account.

Xusuusin^(Note) : Uma baahnid rukhsad Visio^(Visio) si aad u isticmaasho add-in. Si kastaba ha ahaatee, haddii aad haysato shatiga Visio^(Visio) habboon , dooro ' Saxiix'^{(Sign In’)} haddii kale ' Gelida dambe'^{(Sign in later’)} . Tan, waxaa jiri doona hawlo yar oo la furayo ka dib markaad saxiixdo.

Ka samee^(Create) jaantusyada/shaxanka socodka xogta ku jirta Excel

Ku -darka Xogta Visualizer -ka ee ^{(Data Visualizer)}Excel waxaa lagu xoojiyay noocyo kala duwan oo miisaska xogta la tafatiran karo ee Excel . Hadda^(Currently) , Data Visualizer wuxuu bixiyaa saddex nooc oo ikhtiyaari jaantus ah oo ay ku jiraan jaantuska socodka aasaasiga ah^{(Basic Flowchart)} , jaantuska socodka shaqada^{(Cross-Functional Flowchart)} , iyo jaantuska ururka^{(Organization Chart)} . Tusaalooyinkani aad bay u fiican yihiin inay kaa caawiyaan inaad bilowdo, waxay u oggolaadaan isticmaalayaasha inay:

• Ku dar tallaabooyinka habraaca
• Wax ka beddel xirayaasha
• Abuur ku tiirsanaanta
• Geli milkiilayaasha
• Iyo qaar kaloo badan

Xaashidan muunada ah waa meesha laga bilaabayo. Waxaad ku dari kartaa safaf badan, bedeli kartaa Noocyada Qaabka^{(Shape Types)} , oo aad ku wareejin kartaa. Waxaa jira doorashooyin badan oo kale.

Waxaad xitaa kordhin kartaa xaashidan shaqada adiga oo ku dara tiirar badan. Tiirarkani ma beddelaan jaantuska aasaasiga ah ee Visio laakiin waxay kuu oggolaanayaan inaad xaashida shaqada geliso falanqayn ballaadhan.

Isticmaalayaashu waxay si fudud ugu beddeli karaan xogta muunada iyaga oo marka la sameeyo - si fudud u dhufo ' Refresh Diagram ' si ay u arkaan isbeddelada oo la mid ah jaantuska xogta ku xiran ee si sax ah xaashida Excel .

Arag^(View) , daabac, oo wadaag jaantusyadaada/shaxanka socodka

Maaddaama jaantusyadaada Visio lagu abuuray onlayn (lagu kaydiyay OneDrive ama SharePoint si caadi ah) - daawashada, daabacaadda, iyo la wadaaga isticmaalayaasha kale ee Office 365 waxay noqotaa mid fudud oo aan la qiyaasi karin. Mar kasta oo aad rabto inaad ku furto jaantuskaaga Visio ee shabakadda, ka dooro Open in web ka ellipses (•••) ee ku yaal bar menu-ka-gacan.

Fiiro gaar^(Note) ah: Haddii aadan weli soo gelin, waxaa lagugu soo jeedin doonaa inaad ku soo gasho Microsoft 365 ama Office 365 shaqada ama xisaabta dugsiga. Dooro Saxiix ka^{(Sign in)} dibna Oggolow ama Aqbal^{(Allow or Accept)} wax kasta oo ogolaansho ah.

Ka dib markii Visio File la abuuray, dooro ' Faylka Fur'^{(Open File’)} . Halkan ka daawo:

• Si aad u daabacdo^{(To print)} – Gudaha Visio ee shabakada, dooro ellipses (. . .) > Print si aad u daabacdo jaantuskaaga.
• Si aad wax u wadaagto^{(To share)} – Dooro badhanka 'Share' si aad u abuurto xidhiidh ama aad u gasho ciwaannada iimaylka kuwa aad doonayso in aad la wadaagto.

Habbee^(Customize) oo wax ka beddel jaantusyada/shaxanka socodka addoo isticmaalaya wax-ku-darka Visualizer Data^{(Data Visualizer)}

Badhanka ' Tafatirka'^(Edit’) uma shaqeeyo kuwa aan haysan shatiga Visio oo buuxa oo gooni ah. ^(Visio)Shatiga Visio^(Visio) la'aanteed , waxaad ku dheggan tahay nidaamka midabka asalka ah iyo habaynta waa la xaddiday.

Shatiga Visio Online Plan 1 ama shatiga Visio Online Plan 2 , isticmaalayaashu waxay wax badan ku qaban karaan jaantuskooda Xogta Sawirka^(Visualizer) waxayna ka dhigi karaan soo jeedintooda mid xiiso badan. Waxay ku dari karaan qoraal ama sawirro, codsan karaan mawduucyada naqshadeynta, oo ay samayn karaan beddelaad kale si ay u habeeyaan jaantusyada Visio ama Visio Online .

Xariiqda hoose^{(The Bottom line)} - Beddelka jaantuska kaliya ee suurtogalka ah ayaa ka yimid xaashida shaqada ee isha ilaa aad geli karto nooca Visio oo buuxa.^{(The only diagram alterations possible are from the source worksheet unless you can access the full Visio version.)}

Caawinta & Taageerada

Isticmaalayaashu waxay heli karaan taageero dheeri ah waxayna si toos ah jawaab celintooda ugu soo diri karaan Microsoft add-inka iyagoo gujinaya ellipses oo gujinaya ' Caawimo'^(Help’) ama ' dir jawaab celin'^{(Send feedback’)} .

Data Visualizer add-in for Excel waa istaahila in la isku dayo!

Waa inaad isku daydaa Visio Data Visualizer Add-In for Excel . Fur warqad shaqo muunad oo ku ciyaar shaxda socodka si aad u aragto sida arrimuhu u shaqeeyaan.

Xigasho^(Source) : Microsoft.com .

How to use Data Visualizer Add-In for Excel to create Flowcharts

Microsoft Excel is great for numbers, certainly, it does this job really well. But, if you are looking to present your data in an attractive manner that allows you to easily visualize and analyze it, then this amazing product may lack some features. This calls for some support – try out Data Visualizer add-in for Excel.

The Data Visualizer add-in for Excel is a new arm to Excel which can convert an Excel 365 worksheet into a Visio diagram. This add-in allows the users to automatically create high-quality flowcharts, cross-functional flowcharts, and organizational charts—all the shapes, connections, and data linking—from the data in Excel tables. Users will not need to buy Visio to use the Microsoft Visio Data Visualizer in its simple form, just Excel 365 for Windows/Mac or Online. This is one interesting tool and worth trying if you frequently make flowcharts or diagrams.

All you need to get started is an Office 365 subscription—added subscription to Visio is NOT required.

Data Visualizer Add-In for Excel

Data Visualizer leverages the best of Excel and Visio; you enter data into an Excel workbook and Visio creates a diagram automatically. Anyone with an Office 365 subscription can use the Data Visualizer add-in to create Visio diagrams; use the underlying Excel data to modify diagrams; and, view, print, and share diagrams.

This tool is an alternative to the diagram options already in Office which offers limited options and can be quite annoying.

Create Flowcharts & Organizational charts in Excel

The Data Visualizer add-in for Excel is available for:

• Excel on Windows
• Excelon Mac and
• Excel for the web with a work or school account

To install Data Visualizer on any of the above, you will have to follow these steps:

1] Open ‘Excel’ and create a new ‘Blank’ workbook

2] Click ‘Insert’ and then hit ‘Get Add-ins’

3] In the Office Add-ins Store, search for ‘Visio Data Visualizer’ and hit the ‘Add’ button.

4] Now ‘Sign In’ with your account associated with your Office 365 subscription/Microsoft 365 work/ school account.

Note: You do not need a Visio subscription to use the add-in. However, if you have an appropriate Visio license, choose ‘Sign In’ otherwise ‘Sign in later’. In this, there will be few functionalities that get unlocked only after you sign in.

Create diagrams/flowcharts from data in Excel

The Data Visualizer add-in for Excel is powered with a variety of editable sample data tables in Excel. Currently, Data Visualizer offers three types of diagram options including Basic Flowchart, Cross-Functional Flowchart, and Organization Chart. These samples are great to help you get started, they allow the users to:

• Add process steps
• Modify connectors
• Create dependencies
• Insert owners
• And much more

This sample worksheet is just the starting point. You can add more rows, change Shape Types, and switch them around. There are many more choices.

You can even extend this worksheet by adding more columns. These columns do not change the basic Visio diagram but allow you to assimilate the worksheet into the broader analysis.

Users can easily replace the sample data with their own and once done – simply hit ‘Refresh Diagram’ to see the changes sync with the data-linked diagram precisely in the Excel sheet.

View, print, and share your diagrams/flowcharts

Since your Visio diagrams are created online (saved in OneDrive or SharePoint by default) – viewing, printing, and sharing with other Office 365 users becomes unimaginably simple. Whenever you wish to open your diagram in Visio for the web, select Open in web from the ellipses (•••) in the add-in menu bar.

Note: If you’re not signed in yet, you will be prompted to sign in with your Microsoft 365 or Office 365 work or school account. Select Sign in and then Allow or Accept any permission prompts.

After the Visio File is created, select ‘Open File’. From here:

• To print – In Visio for the web, select the ellipses (. . .) > Print to print your diagram.
• To share – Select the ‘Share’ button to create a link or to enter the email addresses of those you want to share with.

Customize & edit diagrams/flowcharts using Data Visualizer add-in

The ‘Edit’ button doesn’t work for those who do not have a separate full Visio license. Without a Visio license, you are stuck with the original color scheme and customizations are restricted.

With Visio Online Plan 1 or Visio Online Plan 2 license, users can do a lot with their Data Visualizer diagrams and make their presentations more interesting. They can add text or images, apply design themes, and make other modifications to customize diagrams in Visio or Visio Online.

The Bottom line – The only diagram alterations possible are from the source worksheet unless you can access the full Visio version.

Help & Support

Users can get additional support and send their feedback directly to Microsoft from the add-in by clicking the ellipses and clicking ‘Help’ or ‘Send feedback’.

Data Visualizer add-in for Excel is worth trying!

You should try the Visio Data Visualizer Add-In for Excel. Open up a sample worksheet and play around with the flowcharts to see how things work.

Source: Microsoft.com.

Related posts

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Gelida Xogta laga soo qaatay muuqaalka sawirka ee Excel

• Sida loogu beddelo Taxanaha Xogta ee garaafka Excel ama jaantuska

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

• Isticmaal Xidhiidhiyaha Xogta PDF ee Excel si aad u soo dejiso xogta PDF xaashida

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Jadwalka xogtaada Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• Sida loogu dabaqo Xaqiijinta Xogta Unugyada Microsoft Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah