Dashboard Question

[leviathan86]

I have attached an example of what I am trying to do to make it clearer. I am using the following example (http://chandoo.org/wp/2011/07/20/int...ng-hyperlinks/)


I would like to have two charts, that are independent of each other. Right now when i mouse over the hyperlinks Attachment 156321 the first graph disspears. however i would like to have that stay.

[leviathan86]

Bump.. any help before this gets booted?

[leviathan86]

Would appreciate some help.

[Andy Pope]

Name cell AA42 as valSelOption2

Alter formula in row 39 to be

=IFERROR(HYPERLINK(highlightSeries2(C36)),"6")

create new udf

Please Login or Register  to view this content.

Change AA41: =MATCH(AA42,$W$42:$Z$42,0)

change array formula in AA43: =INDEX(W43:Z54,,AA41)