I wrote a tutorial recently that uses this technique:
Interactive Controls to Highlight Selected Data in an Excel Chart