Personnel Tracker

[daldershot86]

Good evening,

I'm looking for some help as someone with a relatively basic working knowledge of excel.

I have been tasked with producing a weekly commitments tracker for 2017 for personnel by my boss and have created a basic template that he has approved (see attached file - the actual tracker will have many more categories of task with the numbers of personnel feeding in from another sheet. This is already set-up and is within my knowledge.).

What I want to do now, is present this data graphically (which I can do easily) but using dynamic graphs (stacked and 100% stacked graphs by choice) that will show 4 weeks ahead of the current date based on the with each individual task and then a separate graph showing 12 weeks ahead with pure committed vs uncommitted personnel.

I'm looking for two things if anyone is able to help:

1) Any pointers to guides that might be able to help me achieve this
2) A worked example of how I can do this - once I understand the basics I will adjust to fit my actual tracker.

I've been looking a pivot tables and slicers as a way to do it but don't have the indepth knowledge to know exactly what is possible.

Thank you in advance for any help!

D