Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

visio excel

ResolvedVersion 2010

Claire has attended:
Visio Advanced course

Visio & Excel

I am trying to use the wizard to create an org chart. It keeps saying that the data is unreadable. Can you assist please?

RE: Visio & Excel

Hi Claire

Trying to work out if the problem lies with the Excel file you are using?

Have you used it before to create an Org chart? If not please can you check the following:

Does the Excel file have a column of data with 1 cell as a heading?
Does the data start in the top left hand corner of Excel in A1?
(Merged cells will cause a field problem)

If you could check those items and let me know that will help us to troubleshoot the problem for you.


Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Visio & Excel

Hi,

this is the first time that I have tried to create an org chart from the excel sheet. The titles are in A1. It states that it cannot open the file. ( I have tried various excel files and it won't open any)

RE: Visio & Excel

Hi Claire,

That's very unusual. I'm going to attaching a file to this message so that you can download a sample Excel document to test the import. I know that this file works.

Here is a step by step guide to importing Excel into Visio
https://www.stl-training.co.uk/tip-193-organisation-chart-visio-excel.html

Thanks
Richard B

Attached files...

SampleOrgChart.xlsx

RE: Visio & Excel

Hi Richard,

This has worked! Thank you. I was trying to use any excel table instead of the sample workbook.

RE: Visio & Excel

That's great news Claire!
Glad we could help you with Visio.

Thanks
Richard B

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Visio tip:

Create own ribbon tab - Visio 2010

a. In Visio click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Visio hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.