Hello,
I am relatively new to Excel VBA and so any help is much appreciated. I have a project I have been working on and I really hope someone can help me. It is due tomorrow evening, so in advance, thank you for the help. I really appreciate your time and consideration.
The problem I am facing is that I have an excel file with multiple sheets all originating from a 'DATA' sheet. I also have a code set up so that when new data is put in, all the other sheets up date.
What I am looking for is to create a dynamic line graph that will chart all the columns from the Sharpe, Modigliani, Treynor, Information, Jensen, and Beta sheets against the dates. But, I am looking to have it all in one graph with Check Boxes or something of that sort next to the a appropriate names so that I can compare and contrast whichever ratio from whichever column I want. Also, I am looking to make the graph updatable so that when new information is put into the work sheet via the 'DATA' tab, that graph update as well.
Attached is the file I am working on and the Summary page has the idea I am trying to create.
If you can help me, please feel free to add a new page or something because I know the way I set up the summary page is correct and is very tedious.
http://www.2shared.com/file/mOCY28sn..._Metrics5.html
Thank you again and I appreciate any help.
All the best,
Phil
Bookmarks