Link Excel spreadsheet to a Visio Gantt chart

I was poking around in Visio yesterday, working in a Gantt chart and came across an option to have the data "source" Excel spreadsheet be visible on the bottom of the Gantt Chart. Visually, I was able to see the Gantt on the top and the Excel spreadsheet tasks below. I then used the Link option in Visio and was able to link the two applications. When I updated the Excel spreadsheet, it would also update the Gantt.

For the life of me I cannot recreate this.

Does anyone know how to recreate this scenario?
RatsowhatAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
0
RatsowhatAuthor Commented:
Thank you Rgonzo1971. It is a good article, I have read it. Unfortunately, the company I work for prohibits me from launching any Commands, it opens the operating system up to modification. Too much risk.

The question I posed above is more of a formatting Visio question I think. I fell upon an option in Visio whereby the original excel spreadsheet became visible on the bottom of the Visio Gantt chart. It was awesome. I could see the Excel task and the Visio Gantt at the same time. I was interrupted by a meeting, and when I returned I had clicked on so many options, I lost track of how I had achieved the end result. Grrrrrr... very frustrating
0
Rgonzo1971Commented:
to show the data

pls try

Goto Data - Show/Hide

and tick External Data Window
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

RatsowhatAuthor Commented:
Thanks again, Rgonzo1970. I am using Visio 2010. Under the Gantt Chart tab I do not see an option for "Goto Data"? I see "Go to Start" or "Finish" (referring to the task duration), but nothing about Data. I do have an option to Import Data, or Export Data. Import option was how I populated the Gantt from Excel. I keep wandering back to the Insert tab thinking it must be somewhere on there, but NG.

Appreciate your help immensely.
0
Rgonzo1971Commented:
Data in the level

File - Home - Insert  - Design - Data - Process - Review  - View
0
Rgonzo1971Commented:
Maybe try

In Visio 2010, navigate to Data tab and click Link Data to Shapes button. and follow the wizard
0
RatsowhatAuthor Commented:
Crazy, I know... but these are my tabs:

File, Home, Insert, Design, Review, View, Gantt Chart (No Data tab)

Here's an image:
Capture.JPG
0
Rgonzo1971Commented:
Right-Click on the menu

Choose

Customize the Ribbon

on the right list make sure the Data Tab is ticked

if you don't have Visio Professional you wont have DATA or REVIEW
0
RatsowhatAuthor Commented:
Not even an option for a Data tab
Capture2.JPG
0
Rgonzo1971Commented:
like I said before

if you don't have Visio Professional you wont have DATA or REVIEW

then I don't know how to solve your problem
0
RatsowhatAuthor Commented:
Ok, then.
I now know what happened. My IT team installed a new key yesterday and apparently down graded my version.

like I said before... Appreciate your help immensely
0
Rgonzo1971Commented:
Maybe try to close and reopen visio sometimes if you are entitled to Pro it has to start a second time
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Visio

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.