Chart Question

[littleleaguedad]

I have an Excel Scatter Chart. 2 data series.
I have 3 slicers hooked up to a NON-Pivot table table.
The chart changes data when I change the slicers.
a. I would like the chart title to change with the slicers value.

b. If I can't do "a", then I would like to have a cell value with the slicer value.

c. If I can't do that "b", I would like to set up a cell where the value is from the data. I have tried to do a vlookup on one year of the data to get the title but it only registers the first vlookup value whether it's visible or not. IE it's returning non-visible records. so how do I do a vlookup to exclude non-visible records.

I have no report connections with the slicers since it's not a pivot table.

I have read all of the google solutions and watched youtube videos and I'm not smart enough to figure out the previous answers from google, stackoverflow or this forum, etc. So yes, I'm asking a question that has already been asked.

I have seen the pivottable example for the titles going with columns but I can't connect my pivot table to the slicer after I have already connected the slicer to the non-pivot table data.

Any help would be appreciated.