Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2793735%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2793735%22%20slang%3D%22en-US%22%3E%3CP%3EI%20using%20an%20excel%20spreadsheet%20to%20create%20an%20org%20chart%20in%20Visio.%26nbsp%3B%20I've%20entered%20employee%20data%20in%20my%20excel%20table%20with%20unique%20IDs%20for%20each%20person%20along%20with%20their%20job%20titles.%26nbsp%3B%20When%20I%20create%20the%20org%20chart%20Visio%20creates%20a%20separate%20box%20for%20each%20person%20even%20though%20they%20have%20the%20same%20job%20title.%26nbsp%3B%20Is%20there%20a%20way%20to%20format%20the%20excel%20cells%20so%20that%20when%20Visio%20reads%20the%20data%20it%20see%20the%20one%20job%20title%2C%20creates%20one%20box%20and%20adds%20multiple%20names%20to%20the%20box%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2793735%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2794209%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2794209%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1169477%22%20target%3D%22_blank%22%3E%40PChan840%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20knowledge%20in%20this%20area%20is%20limited.%3C%2FP%3E%3CP%3EBut%20here%20I%20can%20send%20you%20this%20link%20with%20information%20where%20you%20might%20find%20a%20solution.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-organization-chart-in-visio-abb3dd17-2692-439f-9945-3a015767d96a%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20an%20organization%20chart%20in%20Visio%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20with%20these%20information%20%2F%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I using an excel spreadsheet to create an org chart in Visio.  I've entered employee data in my excel table with unique IDs for each person along with their job titles.  When I create the org chart Visio creates a separate box for each person even though they have the same job title.  Is there a way to format the excel cells so that when Visio reads the data it see the one job title, creates one box and adds multiple names to the box?

2 Replies

@PChan840 

My knowledge in this area is limited.

But here I can send you this link with information where you might find a solution.

Create an organization chart in Visio

 

Hope I could help you with these information / links.

 

NikolinoDE

Hi @PChan840 

 

Hope you are doing well. I guess data from your post and try to make chart in Excel. The chart created from sample data shown below. 

 

I create this chart for Microsoft Excel & Office 365.

 

And if you are comfortable with Google Sheets, you can find here.

 

Thanks 

 

Qaiser_j_0-1633439822770.png