How To Create An Interactive Gantt Diagram In Python Using Plotly & Excel | Step-by-Step Tutorial

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I will show you, how to create a Gantt Diagram in Python.

The data is coming directly from an Excel file.
You can do all the changes in the excel file and after running the code again you will have your updated Gantt Diagram.
The Gantt Chart is interactive and will be saved as an HTML file.

You can download the code & excel file here:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[ajayjoseph]

Drag and drop and resize tasks dynamically will be amazing.

[Slayvantz]

This was great! Now I just have to figure out how to get it to work with time instead of dates! Thanks for getting me started.

[shashvatverma]

Pretty cool tool. Can't believe how many free online tools require a payment now, just to use their most basic gantt chart making tools.

[PJMScheduling]

Amazing tutorial! I'm new to Python so forgive me if this is a dumb question, but is there a way using plotly to add a scroll bar to the gantt chart? My schedules can be 1, 000s of activities and I'm trying to find a way to not compress the entire gantt chart onto one window. Cheers!

[cibi]

hey! thanks so much for this video. i'm doing a university project in visualization with python and this helped me so much to get started. I was wondering if you could give me a tip for the most beginner friendly way of making an animated gantt chart in python (so far i couldnt make it work in plotly but maybe you have a tip. Could be basically any library the main thing would be that its possible :D Thanks so much for your asnwer in advance.

[mikepetersen]

Thank you so much for this great tutorial!

[jamilhassan]

Thanks for this video, that's helpful but i'm wondering if there is any way to add a "Comments" column in the excel file in order to add a hover text in the gantt chart?

[py_tok]

very cool mate, thank you, new sub here

[farazmehdi]

Appreciate the tutorial. It helped me a lot. Curious if we can add dependencies to the Gantt chart.

[nailialaeddine]

Amazing tutorial ! thanks so much for this video.i'm doing a university project in visualization with python and this helped me so much to get started.
I'm new to Python so forgive me if this is a dumb question :
Is there a way to manipulate the bars by using the mouse in the image, for example assemble or return, or is there another way?But i want in the same thing(time line), Another library !!, I don't know !?
I hope for an answer.
Thanks in advance 😊

[imranmasoud]

Thank you so much. I want to try this but just to publish my excel table as is. Would it work with this code?

[jawwadrezanoor]

Thank you. This was very helpful. I was just wondering how to allocate different colors (i.e., colors other than the default black) without the % completion data (meaning, all values in % completion column = 0)

[umyaor]

That's a great tutorial. One thing I could not figure out is the date in my Gantt chart always start from 1970. It looks like the date was not read from my excel file somehow. Do you know how to fix it? Thank you.

[TriNguyen-xiji]

Plotly is cool but it is a complete mess regarding Gantt chart. In my case, the bar heights are completely random. Some is like a thread of hair thick, some take literally a quarter of my screen's height. I have looked up and find out that many people are experiencing the same problem and there seem to be no effective way to overcome this just yet.

[chemmakhabderraouf]

Thanks man for the video! I have one question, Can we justify the yticks to the left? I found no solution available yet! I tried to bypass that by adding extra spaces (all ticks with the same character count) to the left of the shorter ticks but apparently the space length is not as the letter length which makes it not possible to have all ticks start at the same (left level).

[nailialaeddine]

hey! Is it possible to put colors in the background of the interface specify a specific time
For example, every day a color or every month a color
something like this
!?
I hope for an answer.
Thanks in advance 😊

[kkkokk]

is it able to change the x-axis from time to numeric positions?(like 1-10000)

[pauladdison]

I had an error in powershell when trying to print output. I installed additional library openpyxl and this seemed to fix the problem. In case anyone else facing similar issue.

[asarma]

How can you make it show that the task finishes in the same day but it only took some hours?