Create Organization Chart in Visio 2010 from Excel Spreadhsheet

[@greenbaby9843]

Found this at just the right time, 5:30am, for later today. Thank you!

[@PandorasBox2]

very good one thou one issue if you change excel file visio wont update with new data and refresh data icon is grayed out!

[@FaysalEasyExcel]

great work. thanks

[@computertutoring]

Thanks 😊

[@chiaracece7399]

Is someone able to please tell me how Visio Pro knows what worksheet in a workbook to use? I have several tabs in one excel workbook. thank you!

[@erikadealday4376]

Hi! I created an Org Chart using an excel upload with the column "Master_shape". I want to link my data so if the position type changes it will automatically update in the Org Chart. Ex. Vacancy becomes Position. I've tried linking my data and changing the position in excel but it doesn't update in the Org chart. Is there a way this can be done?

[@computertutoring]

Hi Sorry don't know a way of doing that you can link the data if you're using professional version but the shape doesn't update.

[@DrSantoshKumarSahu]

Thank you very much

[@computertutoring]

Thanks very much

[@amirhossein1108]

is it possible to create any arbitrary chat including triangles, Trapezius,or arbitrary attached shapes??

[@computertutoring]

As far as I know you have to live with the shapes that are given although in the later version of Visio you can change the shape design afterwards.

[@memo1413a]

How can I merge them to be 1 page instead of different multi pages ?

[@computertutoring]

When you get the option to split by department, don't. Should all go on on one "large" page. Will double check to confirm myself

[@luscious2029]

Hi one doubt how to make big chart in single worksheet. Please help me

[@taev0005]

Hello, how can I adjust the hierarchy on excel to avoid having a specialist on top of the subordinates?

[@computertutoring]

Basically have the specialist report to the manager. Whoever a person reports to will be below them in the hierarchy.

[@taev0005]

@@computertutoring I have both a senior and a leader reporting to a section head. But the senior is always on top of the subordinates and then the leader, I was wondering if there is a way to fix this even when they report to the same person I want the leader to be on top of the subordinates and then the senior

[@computertutoring]

Sorry no I don't

[@07Paule]

Is it possible to make one person report to two different people?

[@computertutoring]

Good question that I know of but if you find a way please let me know

[@tameikabyrd7825]

This didn't work for me. My org chart is separated into different pages. Frustrating. What am I doing wrong?

[@computertutoring]

If you want your org chart to be on one big page you need to select the "I want to specifiy how much of my organisation chark to display on each page". 4:42 in video. Then, after clicking next, choose the name of the person at the top of the hierarchy. Hope that this helps.

[@muhdfarhan2821]

hello there, I wanted to ask, is it possible to update data from excel to visio ? for example we change, edit, delete or add any data from excel and in the visio it automatically update ?

[@sean1857]

have to reimport the data from excel to visio and link the shapes on your visio to excel. your display field in visio should the be the same as excel

[@muhdfarhan2821]

@@sean1857 okay thank you and I also have another question....when I try to import the excel file into the visio.....it contains multiple duplicates because some information in my excel contain vacancies for position and the visio will try to delete the vacant positions ....how do I solve this ? Thank you for your time and consideration...hope to hear from you soon.

[@computertutoring]

Hi if you're having trouble with seeing the employee ID on the shape instead of the name you can use the name as a last resort. kzbin.info/www/bejne/amebg5mKjMmWm5I Only trouble could be if there are two people with the same name.

[@umanair9334]

how to add picture in this?

[@taev0005]

Change the boxes outlays and right click to add a picture