Hi, I'm using the method of creating interactive graphs with hyperlinks mentioned in the site . Refer the below link for the trick used in this workbook.
http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/
Link for workbook : http://img.chandoo.org/d/rollover%20hyperlink%20demo.xlsm
In this i have added a Hyperlink formula "=HYPERLINK("#" & CELL("address",G1),G1)" in cell G3 which works fine until i rollover the hyperlinks (B6:E6) to display charts. When i rollover the hyperlinks (B6:E6) , value displaying in cell G3 is changing. If i go to the formula bar and hit enter without changing anything , value in G3 is dispaying properly.
So please help in this issue , so that even on rollover my value displaying in cell G3 should not change.
Note : The reason i have written the Hyperlink function in such a manner coz in my workbook rows will be added & deleted so using the hyperlink function in such manner the link to the cell changes according to the rows added/deleted.
http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/
Link for workbook : http://img.chandoo.org/d/rollover%20hyperlink%20demo.xlsm
In this i have added a Hyperlink formula "=HYPERLINK("#" & CELL("address",G1),G1)" in cell G3 which works fine until i rollover the hyperlinks (B6:E6) to display charts. When i rollover the hyperlinks (B6:E6) , value displaying in cell G3 is changing. If i go to the formula bar and hit enter without changing anything , value in G3 is dispaying properly.
So please help in this issue , so that even on rollover my value displaying in cell G3 should not change.
Note : The reason i have written the Hyperlink function in such a manner coz in my workbook rows will be added & deleted so using the hyperlink function in such manner the link to the cell changes according to the rows added/deleted.
