Single chart showing different level of details

I use Excel work sheets for planning and tracking of construction activities. our project is divided into different packages and each package will have tasks to be performed. now, i need a chart that is dynamic (should have filters). it should be able to show the progress of each task in a package, each package in the project.

Could you please share us how much u have worked in your macro so that it will be helpful for us to help u.