Exel Graficas

The implementation
After some smaller changes on the dashboard, like adding the option buttons, linking them to the same cell and adding simple conditionalformatting to the columns, the interesting part is the sorting algorithm on the sheet “calculations”. There are various solutions for sorting in excel using formulas. Most ofthem are use array formulas, definitely the most elegant way of doing this, but hard to understand. The step-by-step solution with several “help columns” may not be aselegant as an array formula, but it will probably be easier to understand.
This is how the dashboard sorting works:

* Get the relevant data (depending on thesort criteria) by using the function OFFSET (column E)
* Make sure to have a list with unique entries by adding a very small number (column F)
* Sort the listusing the function LARGE (column G)
* Use MATCH to find the corresponding position of every value within the unsorted list (column H)
* Put together the wholedata table in a sorted form by using the results in column H and OFFSET (columns (J to O)
We are almost there. All we have to do now is changing the starting referencesin the OFFSET-functions on the dashboard (refer to row 9 on sheet calculation instead of row 5 on sheet data). That is all.
Final remarks
If you are using Excel2007, you will notice that the conditional formatting of the cells underneath the option buttons will behave somehow strangely when clicking on another button. If youscroll down until the range is out of sight and scroll back again, everything looks fine. This doesn’t happen with Excel 2003, so it seems to be a bug in Excel 2007.