I have some data and based on that data I want create a graphical dashboard to present to higher management.
1. Team wise
2. When I select any leader, graph only shows agent who reports to that particular leader
I have attached row data for reference.
I am using excel version 2007.
if this process can be automated through VBA that would be great.