Session expiration Your session is going to expireClick here to extend

Budget (€) :

Small project <800

Posted on

3/29/15 9:37 AM

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now


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.