Selection in a field based on another selection

[#1]

Hi guys,

I have a chart that has a list of countries (that are determined where X and Y are on a particular chart).

Example: USA has X=20 and Y= 180. This is just a visual representation of where a particular country is on my chart.
I have another list generated from a database that is a company, and within that company, it has many countries relating to it. I was wondering if there was some way that if I select that company, it would display the selected countries associated with that company.

Database looks something like:
Company         Country

Company A      USA
Company A      USA
Company A      China
Company A      Mexico

Excel sheet looks something like this:
X      Y      Country name:
20   180      USA
14   -180     China
15    163     Mexico

So if I select company A, the countries USA, China, and Mexico would display.

Any help would be awesome !

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Create a chart or straight/pivot table with Country name as dimension. Add a listbox with Company as field. As soon as you select a companie in the listbox the countries for that company will be shown in the chart or straight/pivot table.

[#3]

Thank you!