Hello! I completely understand what you are trying to do here. I work as an analytical advisor during the day to one of the top companies in the world. Pivot tables, slicers, Excel VBA, and even Pivot Charts (including scatter plots) are second nature to me, as I have to deal with very large data sets every day.
I only have one review, as I am new to freelancer.com, which is the reason for my lower bid. Also, because we are both in the USA, if you award me the job, you are free to reach out to me on my mobile number to discuss any other thoughts or needs you have.
Regardless of whom you choose, I wish you the best of luck getting what you need.
Thanks,
Alex