Org Charts in Excel

[rosie0509]

Hello everyone/whoever I am talking to!
I am currently working on creating an Org chart that covers the structure of the company and the projects that each team member is working on. On the second sheet I would like to be able to have a breakdown by project, that automatically populate the various team members on that project. I am not sure whether this is possible or whether it has to be done the other way around but basically any advice would be helpful.

Thanks in advance!
Rosie

 

[Roderick_E]

I would use a list/table and then build a pivot from that and then perhaps some charts.