From a selected line in a chart i want to filter a table or pivot table

Yes, this is possible. It might be better if you can provide a sample workbook.

Here is some code I wrote back in 2009. This code is on the sheet containing the chart object. The chart is a X-Y chart that has a date associated with it. When you click on the point you get a message box with the series name, the date, and the X-Y coordinates. This part of the code, I think I understand. the point is you can get the X-Y data and look up whatever other information you want and then go on from there to set filters.

I also have a function called GetADate (Press CTRL-D) where you enter in a date and it finds the point associated with it. This one had me scratching my head until I realized that I was just plotting a second series consisting of the single point.

I've done this for an X-Y scatter plot with date. I would have to be adapted for other kinds of charts and other data sets.

Obviously, this was a demonstration program: something for me to learn on. I haven't "advanced" the technology beyond playing with it.