How to Make a Dynamic Organisation Chart in Excel - 2 Methods: SmartArt & Visio Add-in.
36.5 هزار بار بازدید -
3 سال پیش
-
Download the featured file here:
Download the featured file here: https://www.bluepecantraining.com/wp-...
Buy the Simple Sheets Organisational Chart Template
https://www.simplesheets.co/a/2147525...
All purchases help to support this channel - thanks!
In this video, I demonstrate two methods for creating an organisation chart in Excel.
The first method uses Excel's in-built SmartArt functionality. The key to success is in the preparation of your data. I demonstrate how to sort your records in the most efficient way for use within the SmartArt Tool.
I also demonstrate how to display name and job title on separate lines within the chart shapes. This can be achieved by concatenation the name and job title fields with the CHAR(10) character, which forces a line break. The video features the formula that will achieve this for you.
The second method will only work with Excel 365 and it uses a Visio data visualisation add-in. I demonstrate how to install the add-in and use your own data to populate the organisation chart. The great thing about this method, is that the organisation chart is based on an Excel table, which makes it dynamic. You only need to add new records to the table for the organisation chart to be updated.
------------------------
Buy the Simple Sheets Organisational Chart Template
https://www.simplesheets.co/a/2147525...
All purchases help to support this channel - thanks!
In this video, I demonstrate two methods for creating an organisation chart in Excel.
The first method uses Excel's in-built SmartArt functionality. The key to success is in the preparation of your data. I demonstrate how to sort your records in the most efficient way for use within the SmartArt Tool.
I also demonstrate how to display name and job title on separate lines within the chart shapes. This can be achieved by concatenation the name and job title fields with the CHAR(10) character, which forces a line break. The video features the formula that will achieve this for you.
The second method will only work with Excel 365 and it uses a Visio data visualisation add-in. I demonstrate how to install the add-in and use your own data to populate the organisation chart. The great thing about this method, is that the organisation chart is based on an Excel table, which makes it dynamic. You only need to add new records to the table for the organisation chart to be updated.
------------------------
3 سال پیش
در تاریخ 1399/12/28 منتشر شده
است.
36,505
بـار بازدید شده