Prevent Rows from Moving when a Table Filter is Applied

In the attached worksheet, rows 34 through 41 contain data that needs to be visible even if a filter is applied to the TeamBellCurveRawData table. For example, if I filter the "Job Level" column to show only associates, because so many rows are hidden, rows 34 through 41 move behind the chart, and are therefore not visible. If I make the chart move and size with cells, it gets way too vertically short when filtering by job level, so that is not a viable solution. Freeze frames doesn't work here.

I am very open to novel solutions. Some kind of floating overlay would be ideal; I just have no idea if such a thing is even possible. Side by side view is not a viable solution in this situation (simply moving everything from columns J through Q to a different worksheet), as per management.

In case anyone is wondering, I can't simply move rows 34 through 41 below the table. It needs to be visible at the same time as the table, and some tables may contain dozens of more rows, depending on the team, which would push the rating categories too far down.

I appreciate any help with this issue! I know it's a strange one.

Hi Applehugger,

No sure if this will help you, but at least it will bump it to the top for a expert to help.

I moved the table below the chart to a new sheet and then used the camera tool.

Have a look at see what you think.

Explanation:
Moved the the table that was originally below the chart to a new sheet(Sheet1), all formula are the OP's, available in the first attachment.
Adjusted the OP's formula reference to the new cell references
selected the new location of the table (A1:I9)
used the inbuilt 'camera' function on the select range
selected the 'Bell Curve" sheets, drew the box, resized and moved it to below the OP's chart

Okay, this is super cool! I have never heard of the Excel camera function before, and it is something that will definitely come in handy in the future. Thank you so much, russkris!

Originally Posted by applehugger

Okay, this is super cool! I have never heard of the Excel camera function before, and it is something that will definitely come in handy in the future. Thank you so much, russkris!

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of each of those who offered help.