Link to home
Create AccountLog in
Microsoft Office

Microsoft Office

--

Questions

--

Followers

Top Experts

Avatar of Ratsowhat
Ratsowhat

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?

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of Rgonzo1971Rgonzo1971


Avatar of RatsowhatRatsowhat

ASKER

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

to show the data

pls try

Goto Data - Show/Hide

and tick External Data Window

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


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.

Data in the level

File - Home - Insert  - Design - Data - Process - Review  - View

Maybe try

In Visio 2010, navigate to Data tab and click Link Data to Shapes button. and follow the wizard

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Crazy, I know... but these are my tabs:

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

Here's an image:
User generated image

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

Not even an option for a Data tab
User generated image

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


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

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

ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971Rgonzo1971

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Microsoft Office

Microsoft Office

--

Questions

--

Followers

Top Experts

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.