Skip to main content
Solved

Data linking to a Gantt Chart

  • March 18, 2020
  • 7 replies
  • 362 views

Keith

Hi Lucidchart

I am trying to create a project plan using the Gantt Chart template. I want to be able to link this to an excel spreadsheet where I record project/task activity so that I can update the gantt automatically without having to create a new one all the time. I am capturing task name start/finish date % complete of activity and status i.e in progress etc.

Is this possible please?

Thanks

Keith D

Best answer by Clara H

Hi Dhruv 

Thanks for posting on the community! you can link data to the shapes on Gantt Charts by using dynamic shapes. To learn how to use these dynamic shapes please take a look at the Data Linking article found in our Help Center. 

If I have misunderstood you please reach out again! Hope this helps!

Comments

Annika W101
Forum|alt.badge.img+3
  • Lucid support team
  • March 18, 2020

Hi Keith 

Thanks for reaching out! Data linking does support auto-update but this is only possible if your diagram is linked to a Google Sheet. When you are using a CSV or excel spreadsheet you will have to manually replace the dataset in order for the updates to push to Lucidchart. I hope this helps! Please see our Data Linking Help Center article for more information and let us know if you have any further questions. 

 


Keith
  • Author
  • March 19, 2020

Hi Annika

Thank you very much for the information. I'll give linking to a Google sheet a go and comeback if I have any issues. 

Regards

Keith


Dhruv A
  • July 24, 2020

Is data linking possible for Gantt Charts? I couldn't find that feature.


Clara H
  • Lucidite
  • Answer
  • July 24, 2020

Hi Dhruv 

Thanks for posting on the community! you can link data to the shapes on Gantt Charts by using dynamic shapes. To learn how to use these dynamic shapes please take a look at the Data Linking article found in our Help Center. 

If I have misunderstood you please reach out again! Hope this helps!


Forum|alt.badge.img
  • December 14, 2023

that article no longer exists.


Micah
Forum|alt.badge.img+20
  • Lucid community team
  • December 14, 2023

Hi @j15marti, apologies! I’ve updated the link to that article above and will include it again here for your convenience. 


Micah
Forum|alt.badge.img+20
  • Lucid community team
  • May 3, 2024

Hi! 👋 Jumping in here because I think you and others who might come across this post may be interested in Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!