Microsoft Excel非常适合处理数字,当然,它确实很好地完成了这项工作。但是,如果您希望以一种有吸引力的方式呈现您的数据,以便您可以轻松地对其进行可视化和分析,那么这个令人惊叹的产品可能缺少一些功能。这需要一些支持 - 试用适用于 Excel的 Data Visualizer 插件。(Data Visualizer add-in)
Excel的数据可视化(Data Visualizer)工具加载项是Excel的一个新分支,可以将Excel 365(Excel 365)工作表转换为Visio图表。此加载项允许用户从Excel(Excel)表中的数据自动创建高质量的流程图、跨职能流程图和组织结构图——所有形状、连接和数据链接。用户无需购买Visio即可以简单的形式使用Microsoft Visio 数据可视化工具,只需(Microsoft Visio Data Visualizer)Excel 365 for Windows/Mac或Online. 如果您经常制作流程图或图表,这是一个有趣的工具,值得一试。
您只需订阅Office 365(Office 365)即可开始使用,无需添加对(NOT)Visio的订阅。
Excel 数据可视化工具加载项
Data Visualizer充分利用了Excel和Visio的优点;您将数据输入Excel工作簿,Visio会自动创建图表。任何拥有Office 365订阅的人都可以使用Data Visualizer加载项创建Visio图表;使用底层Excel数据修改图表;以及查看、打印和共享图表。
此工具是Office中已有的图表选项的替代品,它提供有限的选项并且可能非常烦人。
(Create Flowcharts)在Excel中(Excel)创建流程图和组织结构图(Organizational)
Excel的数据可视化(Data Visualizer)工具加载项可用于:
- Windows 上的 Excel
- Excelon Mac 和
- 具有工作或学校帐户的 Excel 网页版
要在上述任何设备上安装Data Visualizer,您必须按照以下步骤操作:
1]打开“ Excel”并创建一个新的“空白”(Blank’)工作簿
2]单击“插入”(Insert’),然后单击“获取加载项(Get Add-ins)”
3] 在Office 加载项商店(Office Add-ins Store)中,搜索“Visio Data Visualizer ”并点击“添加(Add)”按钮。
4] 现在使用与您的Office 365 subscription/Microsoft 365 work/ school account. “登录” 。(‘Sign In’)
注意(Note):您不需要Visio订阅即可使用该加载项。但是,如果您有适当的Visio许可证,请选择“登录”,(Sign In’)否则选择“稍后登录”(Sign in later’)。在这种情况下,只有在您登录后才能解锁的功能很少。
(Create)从Excel中的数据(Excel)创建图表/流程图
Excel的Data Visualizer加载项由Excel中的各种可编辑示例数据表提供支持。目前(Currently),Data Visualizer提供三种类型的图表选项,包括基本流程图(Basic Flowchart)、跨职能流程图(Cross-Functional Flowchart)和组织结构图(Organization Chart)。这些示例非常有助于您入门,它们允许用户:
- 添加流程步骤
- 修改连接器
- 创建依赖项
- 插入所有者
- 以及更多
此示例工作表只是起点。您可以添加更多行、更改形状类型(Shape Types)并切换它们。还有很多选择。
您甚至可以通过添加更多列来扩展此工作表。这些列不会更改基本Visio图表,但允许您将工作表同化到更广泛的分析中。
用户可以轻松地用自己的数据替换样本数据,一旦完成 - 只需点击“刷新图表”即可在(Refresh Diagram)Excel表中精确地查看与数据链接图表同步的更改。
查看(View)、打印和分享您的图表/流程图
由于您的Visio图表是在线创建的(默认保存在OneDrive或SharePoint中)——查看、打印和与其他Office 365用户共享变得难以想象的简单。每当您希望在Visio for web中打开图表时,请从加载项菜单栏中的省略号 (•••) 中选择“在 web 中打开” 。(Open in web)
注意(Note):如果您尚未登录,系统将提示您使用Microsoft 365或Office 365工作或学校帐户登录。选择登录,(Sign in)然后选择允许或接受(Allow or Accept)任何权限提示。
创建Visio 文件(Visio File)后,选择“打开文件”(Open File’)。从这里:
- 打印(To print)– 在Visio for web 中,选择省略号(. . .) > Print以打印图表。
- 分享(To share)– 选择“分享”(‘Share’)按钮以创建链接或输入您要与之分享的人的电子邮件地址。
(Customize)使用Data Visualizer(Data Visualizer)插件自定义和编辑图表/流程图
“编辑”(Edit’)按钮不适用于没有单独的完整Visio许可证的用户。如果没有Visio许可证,您将无法使用原始配色方案并且自定义受到限制。
使用Visio Online 计划 1(Visio Online Plan 1)或Visio Online 计划 2许可证,用户可以使用他们的数据(Visio Online Plan 2)可视化(Visualizer)器图表做很多事情,并使他们的演示文稿更有趣。他们可以添加文本或图像、应用设计主题以及进行其他修改以自定义Visio或Visio Online中的图表。
底线(The Bottom line)-唯一可能的图表更改来自源工作表,除非您可以访问完整的 Visio 版本。(The only diagram alterations possible are from the source worksheet unless you can access the full Visio version.)
帮助支持
用户可以通过单击省略号并单击“帮助”(Help’)或“发送反馈”(Send feedback’)来获得额外的支持并将他们的反馈直接从加载项发送给Microsoft。
(Data Visualizer)Excel的(Excel)数据可视化工具插件值得一试!
您应该尝试适用于Excel的(Excel)Visio 数据可视化工具加载项(Visio Data Visualizer Add-In)。打开一个示例工作表并使用流程图来查看事情是如何工作的。
资料来源(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.