I was wondering if ProjectLibre (free) or Microsoft Office can be used for their gantt charts to be able to plan out the time taken for tasks on different courses ( there are other things like work, etc for folks) -- and allow folks to plan for internships, when they think they can complete.

Also, when people delay for various reasons, a new timeframe is given. I think having a clear sight of the end would be a motivation to power through and complete it.

As a plus, one gets to add these suites to the resume.

No *YOU* are welcome

https://preview.redd.it/8l3z7662oic81.png?width=915&format=png&auto=webp&s=13e7edcc50b8c01a7485a620aadc6809906b7ee4

Hello!

We are a Mac shop on our PM started to use MS Project Online, and we just can't find the Gantt chart in the view dropdown not can we see the critical path. When we look at the limited doc online, it says that it should be there, just can't see it. Am I crazy?

https://preview.redd.it/wwuma6py0wa81.png?width=2432&format=png&auto=webp&s=3a05a12da497906b60cef5637bf1423887981367

https://preview.redd.it/mm46kozz0wa81.png?width=454&format=png&auto=webp&s=e5c92982fa2febad0a8ed8756e44b237ec02b4a0

My fiancé and I have some home improvement projects coming up with dependencies that we need to start building timelines for. We both need access to view and edit. She’s on a PC and I’m on a Mac otherwise I’d just use OmniPlan.

As titled, i need help on this one.

I created a simple svg gantt chart (see image), but the problem here is that, to have the event placed inside a scrollable horizontal timeline. I cannot use libraries due to project requirement, otherwise D3 would be perfect for this. So anyone here can guide me on how to implement the infinite horizontal timeline using pure SVG and javascript?

https://preview.redd.it/lpnreupklzd81.png?width=1006&format=png&auto=webp&s=f653f44c045a878082de394a5fa0166731ca4a3d

Hi all.

I'm trying to generate a gantt chart using data from a csv file. I've tried lots of things with plotly but I just can't seem to get it.

I'd like to display the start/end times grouped for each day from 00:00 - 24:00 row by row.

The csv file contains this data...

Date,Start,End
22 Nov 2021,12:00,13:00
22 Nov 2021,15:00,16:00

I hope this makes sense. Any ideas?

Hey guy,

I have been using a Gantt chart with multiple tabs as a tracker for some time now. I was recently asked to add a new tab to it and even though I am using the same formula in my conditional formatting as I did in the previous tabs, this time it is not working. I have had been using "=AND(X$#>$Y#, X$#<=$Z#)" as my formula, is this not correct? I am positive that I have just done some silly mistake, but I am having trouble finding it. Thank you.

https://preview.redd.it/2x5167lyaic81.png?width=1816&format=png&auto=webp&s=2e86643fc8eb90dcc208546781e18037209afb25

Introducing a simple, interactive and customizable Gantt-chart component I made in my spare time for Vue 3. Hope you will like it :)

GitHub Repo: https://github.com/InfectoOne/vue-ganttastic
Docs and live demo: https://infectoone.github.io/vue-ganttastic/getting-started.html#install
(refresh page if sidebar links not working)

https://preview.redd.it/0214fr1h6ia81.png?width=743&format=png&auto=webp&s=8a066738c0e5a065cf947b5b7c4b585fa1a1c528

https://preview.redd.it/hn4a6pif6ia81.png?width=738&format=png&auto=webp&s=38443e80513f93df2f3cc7288b1f88a2ae205f4f

Features

• Vue 3 support
• TypeScript support (ships with out of the box type declarations)
• Interactivity (dynamic, moveable, pushable bars with various event handlers)
• Reactivity / Responsiveness (bars will be properly repositioned on width resize)
• Customization options (chart and bar styling, changes in behavior, slots, event handlers etc.)
• Day.js support (uses Day.js under the hood for date-time manipulation)

Available on npm

npm install @infectoone/vue-ganttastic

Hi,
I'm coming from tableau and trying to recreate our visuals in PowerBI. The look I'm aiming for is this:

https://preview.redd.it/x3z6vu8mptd81.png?width=1878&format=png&auto=webp&s=924f81dd8737a2147e5c136625628f7a58df4a05

When recreating it in PowerBI, it looks like this:

https://preview.redd.it/w4kivj98qtd81.png?width=1838&format=png&auto=webp&s=aa27357d7110d03605e0e2ba1b512708cdc24152

Now, I have several questions to match this visual to the target:

1. How can I make the Gantt Bars non-transparent
2. How can the Gantt bars be given straigth ends?
3. How can I change the Y-Axis order? I found this one https://www.youtube.com/watch?v=JWh_IXghLjs, but since the names are purely strings, there's got to be an easier way I suppose.
4. How can I add an outline around the individual elements?

I'm using the Microsoft template for gantt-charts currently.

I'm looking for a visualization that can help me make an interactive version like the top of this pic

Ideally I can import a PDF, PNG, JPEG, etc as the base, then have data driven fields for tooltip info like region name, dates associated, and progress. I could define the regions as a SVG or something, not sure how that'd work...

Hello excel gurus: I searched this sub and several others and could not find what I am seeking. I also looked online and could not find it.

In a nutshell: I am looking to create a simple Gantt Chart that provides a broad overview of 6-10 projects I have coming in the New Year. Each of those will have 6-8 subtasks associated with it.

For example:

• Priority I: Hire a Marketing Person
  • Job Description Due 12.31
  • Post Job: Jan 3 -- Jan 31
  • Resume Review: Jan 17 - Feb 11
  • Interviews: Feb 14 - 25
  • Finalists Feb 28 - March 4
  • Decision March 9
  • Notification March 11
  • Onboarding March April 4

Thinking for the table:

• Y Axis would be each of the projects, with an indent for the subtasks
• X Axis would be Project, Person Responsible, Start Date, End Date (maybe percent complete? Other considerations)

Any thoughts on where I might find a decent Gantt template that would set me up to do this? Or, insights into putting one together?

Mitigating Factor: I totally SUCK at excel, but I have been learning from the keen insights provided here (THANK YOU for that!).

I want to enter the the hours into the P Hr est. Column and have it plot out the hours into days.our orders can last from a few hours to days or rarely months. Any help appreciated... https://imgur.com/a/LSkrPjg

EDIT: thanks for the advice managed to figure it out. https://imgur.com/a/3rFNpPh

I had to create 3 more cells. Start date, end date and task duration.

1. Enter hours into P Hr est. Cell

2. Enter format into cell taskduration =roundup(Phrest.cell/24,0).

This will take your hours and change it into days rounding up to the nearest day. Example 43hours= 3 days.

3. Enter format into start date cell =today(). This will make the start date today's day.

You can however pick any day you like.

4. Enter format into end date cell =workday(startdate cell,task duration cell)-1.

This will take the start date add the task duration and enter the end date into the cell for you. The -1 is necessary otherwise it will add a day to the equation.

5. Enter format into startdate cell for next task =enddate cell+1.

This will continue the next task after the first.

6. Format the last end date cell for the second task. After this you can select cells you want to follow this format along with these cells and press Ctrl+D to copy this to all the cells you need it for.

7. Format start date cell =IF(AND(schedule start cell&gt;=enddate cell,&lt;=enddate cell,schedule cell&amp;amp;lt;=enddate cell),"X",""). Reddit/mobile is screwing the format on this > is the greater than symbol < is the less than symbol.

Add in $ where I have otherwise it'll plot it odd.

This will plot "X" into the start date cell.

Select all the cells you want to follow this format and click Ctrl+D to apply it.

8. Go to conditional formatting and select highlight cell rules, equal to.

9. Select custom format.

10. Select the colour you want the cells to be. In Fill tab.

11. Select the same colour in the font tab.

This is so you won't see the X's.

Then press OK.

12. Place an X into the box and press OK.

🙂 it should now. Be complete.

Hi guys, I’m a Year 13 who was taught this last lockdown, so I struggle with it quite a bit. Are there any algorithms that can be used to create Gantt/Cascade Charts for a graph, especially the ones which ask about worker allocation and reconfiguring the activities. Thanks!

It would be great if we can have a Gantt chart in notion.

Am I missing something here or there is not such function yet?

I want to have a timeline that shows some duration and milestones that I can export to PDF. I tried doing it from the report, timeline visualization view and planning console within a project.

I want just the title of the task to be shown and duration if it is not a milestone but I can't configure it or change it so it is not a hover over and will show when I print it.

Any ideas?

I have seen the bolt one where they use google charts but I really don’t want to mess around too much with config. There is another on git which hasn’t been maintained which looks great but also requires fiddling around to get working.

I’m actually a bit shocked Salesforce doesn’t have this out of the box coming from airtable.

Hello everyone,

I am building an online Gantt Chart tool. I made it available for public for free and I would like to request a feedback.

Current version provides an editor which allows to build a Gantt Chart using three types of tasks (Task/Project/Milestone), manage connections between tasks, resize the chart, export task list to CSV and import from CSV.

I have further plans to improve this tool such as to implement user account registration, nested tasks, drag-n-drop of tasks, release standalone app and redesign chart display.

Feedback of the community would be really helpful for planning of the roadmap of the product. Existing functionality will remain free, same as new features for small teams.

Here is the link to PMThings - Gantt Chart tool for anyone interested.

Thank you!

https://preview.redd.it/er6zdhezrxk71.png?width=1380&format=png&auto=webp&s=96f3c625ea89ee5cfc920b74e98e6a3e5b3d8bc0

Aleksei

Hi there! This is my first post and I’m a real newbie when it comes to excel Gantt charts. Is there any way that I can use conditional formatting to colour code the progress bar to correspond with the name of the person I have assigned the task to? All of my bars are purple, and I have the names in column C. I want to be able to see at a glance what tasks my team are working on in any given week. Thanks I’m advance for your help!

Excel for MS365, on desktop

Edit to add: The purple bars are based on a date range- task start date in column e and end date in column F. the formula is =AND(task_end>=CE$5,task_start<CF$5)

OnlineGantt is a 100% free MS Project alternative for simple gantt charts. Users can create project plans with tasks and schedules, save as .gantt files and share with anyone to open and edit for free with a web browser. No signup and no download required.

https://www.onlinegantt.com

Hello!

I want to create a Gantt chart for multiple projects and be able to see the progress for multiple projects at the same time. I'm new to creating Gantt charts and am finding it hard to do so. Could someone help me? I have 9 more main projects to organise like this. What I want to be able to see is the overall progress for each project and the progress in each sub-sub task in my chart. The main project is for 1 year and the subprojects have various timelines but are within the 1 year period.

If possible, could someone share any vids, tips, resources, tools etc? I would love to use Jira and other resources but unfortunately, I can't use paid tools TT so have resorted to creating a Gantt chart in google sheets.

This is what my project(s) look like:

Main Project

Project 1

• Task 1

1. Prep 1
2. Prep 2 ...... 9

• Task 2

1. Prep 1
2. Prep 2 ...... 7

.

.

.

• Task 9

Project 2

.

.

.

Project 10

I need to produce a timeline gantt chart for construction projects on my MAC. Previsouly I have used Microsoft Project. Can anyone recommend a really good and very similar product?