

To learn more about this, see Enhance your data with data graphics. If you set your Visio org chart to carry data from your spreadsheet, it can also be used as a dashboard to track performance, budget spending, and more. Make sure that your spreadsheet includes the exact name of the photo file (for example, susansmith.jpg) so the photo is added to the right name on the chart. At minimum, this source should include each person’s name and who they report to, so Visio can use it to build the chart’s structure.Ī file with photos, if you want the chart to include them. Your data source, such as Excel worksheet, database or Exchange directory. In the example below, the Get requirements shape has a data graphic showing the amount of work complete. A data graphic is a visualization of a data field. When data gets imported and linked to a shape, the data is displayed as a data graphic. This video shows how to generate an org chart, complete with photos automatically added and personnel information available at a click.īefore starting, you need to have a couple things ready: It is being visualized as a data bar, and the bar is filled up to 90. Visio builds the org chart for you, if you have your org’s personnel data on a spreadsheet such as an Excel worksheet. You can use many programs, including PowerPoint, to build organization charts.
