Salary benchmarking: hit the brick wall

[Oredo]

Hello everyone,
Been some time I've posted here, but this has been bugging me for few days now and i cant wrap my head around:

Problem: i have employees salary data and i have market max/ave/min salary data. 1. make stacked floating chart for market data and put scatter points per categories (done).

Question: how to make chart interactive for department and job description?
I'm adding picture of my sample data to make it more clear what i mean.
Just to let you know, i have over 200 unique job descriptions and 500+ employees. maybe there is some other solution, i would like to hear it all.

If its not feasible in excel, maybe power BI has something to offer?

 

[SpillerBD]

Using slicers for Tables, Charts or Pivot Tables may be a place to look.
With that many Job descriptions, you may need to break that down into sections so any one slicer does not have too many options.

 

[Oredo]

Pivot table would be ideal, but unfortunately it doesn't allow me to scatter plot data points (employee salaries) in pivot chart. Is there a way to connect pivot chart and regular table to be connected on slicer?