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]

It should be:
=IF(ISERROR(HYPERLINK(HIGHLIGHTSERIES(F19))),"6",HYPERLINK(HIGHLIGHTSERIES(F19)))

 

[ajay_gajree]

Thank you very much Rory!

 

[RoryA]

No problem. Have you got it all figured out yet?

 

[ajay_gajree]

Hi Rory,

Yes it is now working, thank you for your assistance.

 

[ajay_gajree]

The last thing would be the Conditional Formatting, is this straightforward? I have not used this before.

 

[RoryA]

Yes, it's quite simple.

 

[ajay_gajree]

I put in two conditions in the Conditional Formatting Box, one for the cell with the hyperlink and once for the cell range of the chart and then set the required formatting.

This has not worked

Any suggestions?

 

[RoryA]

How did you apply the conditions and what did you apply?

 

[ajay_gajree]

I changed the background to a different colour

Condition 1:

Cell Value is equal to =$F$27

Condition 2:

Cell Value is between =$C$29 and =$M$52

----

This has just coloured $F$27 yellow,

 

[RoryA]

Which cells did you apply that to? F27? If so, that's why it's yellow.