HighlightSeries - VBA

[vasim]

Hi Please dont beat me for asking this. I have a lot of data, with the help of chandoo highlight series link, I’m able to get the count within the data for parameter on which mouse is rolled.

However I would also like to filter the actual data based on mouse rollover, something like

Public Function highlightSeries(seriesName As Range)

Range("A23") = seriesName.Value

Sheet1.Range("$B$2:$AW$2").AutoFilter Field:=47, Criteria1:=Sheet2.Range("C2")

End Function


Any help...

 

[Luke M]

Hmm. It's not a filter, but we could go about it another route. Since we can change a cell value using this technique, we could combine it with some formulas like the ones I describe here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


So, the mouse-over changes cell value, and the formulas display the "filtered list". Would that be acceptable?


Note: Depending on the size of your data, this could cause performance issues. Everything has a cost. =/

 

[vasim]

Thanks Luke...


We have agreed to scrap this part, (the filter one). Anyways thanks for again reminding me to think Out of Box - in Excel atleast.