Question about Gantt chart

[TopTeller]

thread913-1489078

Most of the resources in the old thread are not up-to-date.

Does anyone have new resources on creating Gantt Charts? Perhaps some free templates in Excel?

 

[SkipVought]

Hi,

Are you wanting help for MS Project or Excel with respect to gantt charts?

I can help with Excel. And if that's the case, please repost your question in Forum707, including sample data you want to display in a gantt chart.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[TopTeller]

I'm looking for some ready-made Ganntt templates or good tutorials on creating them.

 

[SkipVought]

A Gantt chart 'templet' if you will, needs data in a certain format. Do you know what that format is?

BTW, I just Googled excel gantt chart templates and got a bunch of links.

But it takes some Excel experience to get from there to a functioning Gantt chart that takes YOUR data and whips it into shape for the Gantt chart of YOUR dreams. That's what Tek-Tips is all about.

Ball's in your court.

The link I meant to post was Forum68, along with some sample data you want to chart.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[TopTeller]

I know how to use google. What I don't know is whether what I find is any good. Are these any good?

https://exceltemplate.net/gantt-chart/

I can't judge. VBA/macros is way outside of my wheelhouse for now so I was looking for something easy and simple to manage.

 

[SkipVought]

So which option from that site interests you? Then I'll look at that link.

table of content
Excel Gantt Chart with Conditional Formatting
Gantt Chart for Multiple Projects
Gantt Chart Milestones
Gantt Chart Planner
Gantt Schedule Planner
House Construction Gantt Chart
Product Development Gantt Chart
Gantt Chart with Budget and Staffing Plan
Simple Gantt Chart
Simple Gantt Chart Maker
Team Gantt Chart
Free Gantt Chart

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[TopTeller]

Simple Gantt Chart Maker

 

[SkipVought]

Frankly, I've been thru the gantt chart portion and the Simple Gantt Chart Maker link and I can't find a download to the two charts, 1. Simple Gantt Chart Maker with Completions by Day & 2. Simple Gantt Chart Maker with Completions by Week???

How about you?

I'm shooting in the dark here cuz I really don't understand what you need. Since I can't find a download at the site you posted, I went looking and found this Gantt that does not use an Excel chart but it is an Excel solution on a sheet. I've used this sort of rough charting in cells and it does display a rough progress color coded for each bar based on a percent complete that the user would need to supply for each task.

https://templates.office.com/en-us/Simple-Gantt-Chart-TM16400962

What do you think?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[TopTeller]

It's similar to the one on the ET website (to download, click "yes" on the download page).
I like the one you posted, thank you very much, this really does help.

 

[SkipVought]

Great! If you have questions regarding that Gantt, please post in forum68.

Good luck.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[TopTeller]

Will do! Thanks again