Simple Gantt Chart - Need to change from Months to Weeks

[JCBenny]

Hey guys,

I created a gantt chart from a template because I needed to fill something out quick. Everything is going well but my boss would like to see the gantt chart displayed in weeks, not months. 

It looks like it "hard coded" in there and I'm not sure how to fix this becuase it trickles down into "days" and "day of the week". 

All I really need is weeks displayed if possible.

Can anyone help? I'd really appreciate it.

File is attached. Thanks!

[#2 · Accepted solution]

@JCBenny 

See the attached version

[#3]

@HansVogelaar 

Thanks so much for helping out with this! I showed it to my boss and he came back and said he'd like to see month by month into week by week, is that something you could also help with, sorry for the back and forth.

If I knew how to accomplish this I would knock it out but it's alittle out of my expertise.

[#4]

@JCBenny 

What exactly do you mean by "month by month into week by week"?

[#5]

@HansVogelaar 

In the original attachment, it broke it down from month, to day of the month, to day of the week. Instead he is looking to break it down from month down to week of the month.

So in the one you sent, if above each set of weeks was the month they corralate to, I think that would be perfect.

I've reattached the original becuase we have input alot of information since I started this thread so I'd like to work from this one if possible.

Thanks again for helping me on this! Please let me know if I'm not explaining as well as I could be.

[#6]

@JCBenny 

C'mon - I'd have to do all the work I did all over again...

[#7]

@HansVogelaar 

No need man, I didn't know. 

You don't have to do this at all. I'll mark it as complete.

Thanks anyway

[#8]

@JCBenny 

If you attach the workbook that I posted with the new data, I could look at it.

But I don't want to redo all the steps.

[#9]

@HansVogelaar 

Understandable, attached is the version you worked on. I don't think I can copy you're work/formulas into the updated one without breaking it so I'll just pull the updated info into this one if it's solveable, but I can only upload a copy as its consistenly being used by some team members.

Thanks again

[#10]

@JCBenny 

Perhaps like this:

[#11]

Yes perfect, that'll work for me!

I'll stop bothering you now

Thanks!

[#12]

@HansVogelaar 

please, how can I change the gantt chart from weeks to months or better still compress it such that when i convert it to an image, the task timeline can be seen throughout the project and none is excluded.