Project Tracking Calender

[rehanemis]

Hi Professionals,

I would like to make a calendar in excel for project tracking like the attached image. I would like to choose a whole project date and then tasks with dates of project and it will show in coloring with dates.

Can any body suggest or can give me link from where i can get help.

Your help will be highly appreciated.

Rehan

 

[plog]

That's called a Gantt chart. Search this forum and google this term: "Excel Gantt Chart"

 

[rehanemis]

Thanks Plog. Very sorry, I have mean to develop this in MS Access. Have you idea about it.

Thanks

 

[plog]

Do you want just the report or is this to be a form that users can interact with? If a form, how would they interact with it?

In either case, this is going to take advanced level VBA coding. Ever code in VBA before?

 

[rehanemis]

Once we define the project date and sub tasks dates of project i may willing to see it in form or report what is suitable.

I have not did expert level coding. If you please to provide me any reference Access DB or any helping material that how can i start it.

 

[spikepl]

WHy would you want to code this yourself?

Access really is not much good at Gantt. But you can buy a Gantt-chart tool for Access - google it. Developing something of similar functionality is many hours of expert coding.

Also, free Open Source Project Management tools exist that include Gantt and the entire data interface. Google.

 

[rehanemis]

Thanks,

I will try for it.

Thanks again for ideas'