There are several options for this. The easiest and most powerful would be to create a pivot table report of your data and accompanying pivot chart. In this case, you place the Job level at the page level filter and the Job titles and sectors in the row and column (either way depending on the analysis). The values can be set to count or if you have other numerical data then accordingly. Once the data is arranged appropriately, you can create a pivot chart from this. It will allow choosing of the Job level or sector (in the same way the pivot table has been set up).
Alternatively you could use some type of filtering on the data can apply the filter to the chart(s) source data; however making this dynamic may require some VBA code.
