Data Visualizer has been around for awhile, but the org-chart stuff is a new addition to basic flowcharts and cross-functional “swimlane” flowcharts and.New employees are added automatically, deleted employees are removed, and reassignments are redrawn and reconnected.If you do have Visio you can open and edit the drawing in Visio Online or Visio Desktop, but this is not shown in Video.However, you do need to have Excel for Office365.You don’t need a Visio subscription if the org-chart is embedded in Excel.This is not only seriously cool, but it will save you hours of drudgery! Some Highlights That means shapes get added or deleted along with records, and shapes get connected and arranged according to that data. You don’t get new shapes when new records appear, and shapes don’t get deleted when records go away (although there are some notifications to help in these areas though!)ĭata Visualizer takes the next step by creating whole systems of shapes (aka “diagrams”!) that are linked to data.
Visio basic flowchart data visualizer update#
Data graphics allow text, colors and icons to update inside of Visio shapes when linked data changes. Yes, we’ve had data graphics for many years, which can be linked to data sources that change. I’ve been remiss in covering the Data Visualizer (it’s been a busy year…), but essentially Microsoft is starting to create tools that can create and update particular Visio drawing types automatically. It is concise, really well-done, and shows you exactly what you need to know. I just found a great video that showcases a new feature where Visio organization charts are automatically built and updated within Excel, using Excel data!įellow MVP and Excel expert Leila Gharani has produced an excellent video that is not too heavy and not too light.