gutswe
09-07-2011, 03:32 PM
Hi, I'm using the method of creating interactive graphs with hyperlinks mentioned in the site . Click on cell G6 in the attached workbook for link of the technique used.(unable to paste link in post)
The workbook attached is the sample provided at the above mentioned site.
In this i have added a Hyperlink formula 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.
The workbook attached is the sample provided at the above mentioned site.
In this i have added a Hyperlink formula 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.