Step-1:
Open a Microsoft excel sheet and create the database with three fields namely NAME,POSITION,MANAGER as shown in step 2.
Step-2:
Now, save the excel sheet with a name.
Step-3:
Now open a new Microsoft Visio file.
Step-4:
Now in the Microsoft Visio file select the "data" option in the menu bar.
Step-5:
There appears a drop down box as shown below figure and select the "organization chart" option in it.
Step-6:
After selecting the organization chat option, an drop down box called organization chat wizard appears. You need to select information that's already stored in a file or database option and click next.
Step-7:
Select the option as shown below and then click next.
Step-8:
Now locate the file that contains your organization information and click next
Step-9:
Choose the columns(fields) in your data file that contains your information as shown below and then click next.
Step-10:
Now choose the column(fields) from your data file that you want to display as shown below and then click next.
Step-11:
Now choose the column(fields) from your data file that you want to add to organization chat shapes as shape data fields and click next.
Step-12:
Now click the finish option in the dropdown box appears.
Step-13:
Finally we observe the organization chart as shown below for the given created database.
No comments:
Post a Comment