I have an Excel worksheet I have been working on for some while now.
When a company Ticker is clicked on, A rollover graph lists certain figures like Sales, Income etc. related to that company for the last 10 years.
I am struggling to:
(1) Make the graph appear as a layer, so that if I scroll down the worksheet, the graph has to stand still on the screen (not disappear with the scroll)
(2) Keep link references unchanged on sorts and filters. When I run a filter on the companies (i.e. market capitalization larger than say 10000), the places of the hyperlinks change, and hence I get jumbled up results. I require this to be corrected as well.
I wish to be able to change your code, so please make it available in excel.