Microsoft Excel is nice for numbers, actually, it does this job rather well. However, if you need to current your information in a pretty method that enables you to visualize and analyze it simply, then this wonderful product could lack some options. This requires some help – check out Data Visualizer add-in for Excel.
Whilst you can use SmartArt Graphics or Shapes Instrument to create a Flowchart in Excel, in this publish we’ll discuss in regards to the Data Visualizer add-in for Excel, which is a brand new arm to Excel which may convert an Excel 365 worksheet right into a Visio diagram. This add-in permits the customers to mechanically create high-quality flowcharts, cross-functional flowcharts, and organizational charts—all of the shapes, connections, and information linking—from the info in Excel tables. Customers won’t want to purchase Visio to use the Microsoft Visio Data Visualizer in its easy type, simply Excel 365 for Home windows/Mac or On-line. That is one attention-grabbing software and value making an attempt if you happen to steadily make flowcharts or diagrams.
All you want to get began is an Workplace 365 subscription—added subscription to Visio is NOT required.
Data Visualizer Add-In for Excel
Data Visualizer leverages one of the best of Excel and Visio; you enter information into an Excel workbook, and Visio creates a diagram mechanically. Anybody with an Workplace 365 subscription can use the Data Visualizer add-in to create Visio diagrams, use the underlying Excel information to modify diagrams; and examine, print, and share diagrams.
This software is another to the diagram choices already in Workplace, which gives restricted choices and may be fairly annoying.
Create Flowcharts & Organizational charts in Excel
The Data Visualizer add-in for Excel is obtainable for:
- Excel on Home windows
- Excelon Mac and
- Excel for the online with a piece or college account
To put in Data Visualizer on any of the above, you’ll have to comply with these steps:
1] Open ‘Excel’ and create a brand new ‘Blank’ workbook
2] Click on ‘Insert’ after which hit ‘Get Add-ins’
3] Within the Workplace Add-ins Retailer, seek for ‘Visio Data Visualizer’ and hit the ‘Add’ button.
4] Now ‘Sign In’ together with your account related together with your Workplace 365 subscription/Microsoft 365 work/ college account.
Word: You don’t want a Visio subscription to use the add-in. Nonetheless, in case you have an applicable Visio license, select ‘Sign In’; in any other case, ‘Sign in later’. On this, there shall be few functionalities that get unlocked solely after you signal in.
Create diagrams/flowcharts from information in Excel
The Data Visualizer add-in for Excel is powered with a wide range of editable pattern information tables in Excel. Presently, Data Visualizer gives three sorts of diagram choices, together with Primary Flowchart, Cross-Useful Flowchart, and Group Chart. These samples are nice to assist you to get began, they permit the customers to:
- Add course of steps
- Modify connectors
- Create dependencies
- Insert homeowners
- And way more
This pattern worksheet is simply the place to begin. You possibly can add extra rows, change Form Sorts, and swap them round. There are lots of extra decisions.
You possibly can even lengthen this worksheet by including extra columns. These columns don’t change the essential Visio diagram however enable you to assimilate the worksheet into the broader evaluation.
Customers can simply change the pattern information with their very own and as soon as finished – merely hit ‘Refresh Diagram’ to see the adjustments sync with the data-linked diagram exactly in the Excel sheet.
View, print, and share your diagrams/flowcharts
Since your Visio diagrams are created on-line (saved in OneDrive or SharePoint by default) – viewing, printing, and sharing with different Workplace 365 customers turns into unimaginably easy. Everytime you want to open your diagram in Visio for the online, choose Open in net from the ellipses (•••) in the add-in menu bar.
Word: For those who’re not signed in but, you’ll be prompted to signal in together with your Microsoft 365 or Workplace 365 work or college account. Choose Signal in after which Enable or Settle for any permission prompts.
After the Visio File is created, choose ‘Open File’. From right here:
- To print – In Visio for the online, choose the ellipses (. . .) > Print to print your diagram.
- To share – Choose the ‘Share’ button to create a hyperlink or to enter the e-mail addresses of these you need to share with.
Customise & edit diagrams/flowcharts utilizing Data Visualizer add-in
The ‘Edit’ button doesn’t work for many who don’t have a separate full Visio license. With out a Visio license, you might be caught with the unique shade scheme and customizations are restricted.
With Visio On-line Plan 1 or Visio On-line Plan 2 license, customers can do loads with their Data Visualizer diagrams and make their shows extra attention-grabbing. They’ll add textual content or pictures, apply design themes, and make different modifications to customise diagrams in Visio or Visio On-line.
The Backside line – The one diagram alterations potential are from the supply worksheet except you possibly can entry the total Visio model.
Assist & Help
Customers can get extra help and ship their suggestions instantly to Microsoft from the add-in by clicking the ellipses and clicking ‘Help’ or ‘Send feedback’.
Data Visualizer add-in for Excel is value making an attempt!
You must strive the Visio Data Visualizer Add-In for Excel. Open up a pattern worksheet and mess around with the flowcharts to see how issues work.
