Interactive Dashboard on Chandoo Site

[ajay_gajree]

http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/

Hi Everyone,

Has anyone seen this cool looking Dashboard on Chandoo's site,

Was wondering if anyone had got this to work on Excel 2003 and if so could they provide more details instructions for Excel Novice's like me

Best regards

 

[RoryA]

Other than the use of IFERROR instead of IF(ISERROR( I can't see anything that is version specific there. What specifically are you having an issue with?

 

[ajay_gajree]

"Lets call the series name in fifth column as “valSelOption“. Lets assume that we will use some sort of magic to change the series name.
Note: Using this series name, we can fetch the position of the series out of 4 with MATCH formula. Once you know the position, You can fetch corresponding values using INDEX() formula."

Just not sure how to start!

I have set up my data, 4 columns, same as the example.

How do I set a series name for the 5th Column?
And then how do i use the index formula / match formula as described?

 

[RoryA]

Select the data and then type a name into the name box (left hand side of the formula bar).
The INDEX and MATCH parts of the article are actually links to articles on how to use those functions.

 

[ajay_gajree]

Thank you Rory,

I've named the Column, the links to the Matching formula was too generic for me to understand how to relate it to the example

 

[RoryA]

Did you download the example file?

 

[ajay_gajree]

I am using Excel 2003, so the file came out unintelligible.

 

[RoryA]

If you download the compatibility pack from MS you will be able to open 2007 format files, so you can see what is going on.

 

[ajay_gajree]

Thank you for your assistance Rory. I have requested to get this from my IT.

Best regards

 

[ajay_gajree]

Hi,

In relation to the above,

=IF(ISERROR,(HYPERLINK(HIGHLIGHTSERIES(F19)),"6")

Can someone please advise how my formula is incorrect?