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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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:
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
Rgonzo1971Commented:
to show the data

pls try

Goto Data - Show/Hide

and tick External Data Window
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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.
Rgonzo1971Commented:
Data in the level

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

In Visio 2010, navigate to Data tab and click Link Data to Shapes button. and follow the wizard
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
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
RatsowhatAuthor Commented:
Not even an option for a Data tab
Capture2.JPG
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
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
Rgonzo1971Commented:
Maybe try to close and reopen visio sometimes if you are entitled to Pro it has to start a second time

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.