It resource management

Good day!

Novice user here.

I am trying to create a 'graphical' view of the IT resources and their availability both WEEKLY & MONTHLY. The IT resources consist of 5-6 roles, with each working on multiple projects with different START and END dates. I want to graphical represent the overlapping days to show if they are UNDER or OVER utilized.

Example:

Project Manger working on 3 projects. 40% time allocated to 3 different timelines. When the dates overlap, I would like the % allocation to total and be represented by a colour if they are OVER or UNDER utilized. For instance, the Project Manger with 40% allocation per project, and 3 timelines could potentially have a 120% utilization, I would like that to be highlighted or showed graphically.

What I would like is a table to enter:

HUMAN RESOURCE
PROJECT
START DATE
END DATE
% Allocated

Each resource can be used for multiple projects, with different % allocated per project, but mostly what I would like to accomplish is a VISUAL view of how each is being over and under utilized.

I think I can graphic them each over a timeline, but i would like them to collapse into one with the % totalling for the overlap.

Does this make sense? I'm willing to pay for any help! things are that desperate.

Attached is what i would like the visual to look like. RED indicating close or over 100% utilization, and YELLOW representing the other end of the spectrum.


THANK YOU, THANK YOU, THANK YOU. ANY HELP IS APPRECIATED. YOUNG AND KINDA DUMB.