• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I get table task list displayed in a calendar format?

Devota

New Member
I need help. I have a list of tasks for multiple projects with assigned resources and start to end date. How can I get this displayed in a calendar format? I am trying to get an overview of all projects and their resource allocation for the team. My data table have a simple list of tasks, resource assigned, start date and end date.

Thanks you for your help!
 

Attachments

  • TestFile.xlsx
    9.7 KB · Views: 4
Devota

Firstly, Welcome to the Chandoo.org Forums

I assume you mean Gannt chart style?
like:
upload_2016-5-19_8-44-30.png

See your file attached for details
 

Attachments

  • TestFile.xlsx
    25.5 KB · Views: 12
Hi Hui

Thanks for the below, yes that chart I helpful and I have been able to create some variation of Gantt charts from template but for easy visualization of resource availability my management prefer the normal calendar view with names (resources) and tasks populated on each day on the range.

Please see attached thanks!
 

Attachments

  • ProjectsMasterlist_ResourcesTasks.pdf
    73.4 KB · Views: 14
Back
Top