Hi,

Please find the workbook attached.

I'm trying to build a tool that compares projects with the same characteristics (or dimensions).

The problem is that I want to filter the bar chart by:

1) First, I want to be able to filter the bar chart by the usual quick filters (in this case, Type and Brand).

2) But alternatively and at the same time, I want to select a project and automatically show ONLY those projects with the same Types and Brands as the selected project.

In our example, I would be able to select Types and Brands and that would filter the bar chart. However, when I select Project 2, the bar chart will automatically be filtered by Type = 2 and 3, and Brand = 2 and 3 (you can see which Types and which Brands are included in each Project in the Project-Type and Project-Brand sheets).

Do you have any idea how can I do this?

Thank you in advance for your help!

Carlos