visio gantt chart update with excel data

Started by unalu, October 10, 2017, 10:33:52 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

unalu

Hello
I want to link my excel data to gantt chart shape in visio to update values in excel and reflect in gantt chart accordingly.
After I import my excel data into visio, i am trying to link this data (row data) to my gantt chart shape by drag-drop or through menu data link option. But updated data is being reflected in shape data but not being reflected in gantt chart frame itself.
all column names in gantt chart and in excel data are same and i refer (task #) column as ref. column to match data.
but when I link relevant data row to each object in same task line in gantt chart frame, start dates are being updated for example, but not finish date or duration or task name being updated even though i drag and drop onto each cells in same task line in gantt chart
When i click on task name for example , i can see updated data in shape data window as it is linked already to my excel data, but that value or text do not show up in the drawing (gantt chart)
When i try this data linking on other shapes than gantt chart (timeline block e.g.) i dont get such issue and once it is updated in shape data, it is being reflected in drawing too.
Can you please assist on that?
Thanks