One new nice feature of Excel 2010 is the Slicer. Usually, slicers are used to filter data in a PivotTable. But they might be also useful to parameterize an algorithm or a chart! We discussed this technique in our book, but Alberto Ferrari wrote a post that shows how to use this technique to allow the user to select two stocks that should be compared in an Excel Chart – as you might imagine, this will work also when you will publish the workbook on SharePoint!
This is the result:
Nice to see that we use a Microsoft product to show how well Apple shares have been in the last two years!
You can find more info on www.powerpivotworkshop.com. Hope to see you there!