locked
hi RRS feed

  • Question

  • fixed.. thanks
    • Edited by Dmanphil Wednesday, March 21, 2012 5:27 PM
    • Moved by Jie Bao Thursday, March 22, 2012 5:10 AM (From:Visual Basic General)
    Tuesday, March 20, 2012 8:20 PM

Answers

  • I would recommend posting to the Excel for Developers forum, or perhaps a moderator can move your question there. This forum is primarily for Visual Basic .NET.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Proposed as answer by Renee Culver Tuesday, March 20, 2012 10:26 PM
    • Marked as answer by Mr. Wharty Friday, June 1, 2012 1:18 AM
    Tuesday, March 20, 2012 8:30 PM

All replies

  • I would recommend posting to the Excel for Developers forum, or perhaps a moderator can move your question there. This forum is primarily for Visual Basic .NET.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Proposed as answer by Renee Culver Tuesday, March 20, 2012 10:26 PM
    • Marked as answer by Mr. Wharty Friday, June 1, 2012 1:18 AM
    Tuesday, March 20, 2012 8:30 PM
  • Hello Dmanphil,

    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/Performance_Metrics5.html


    Thank you again and I appreciate any help.


    All the best,
    Phil

    Welcome to Msdn Forum , for VBA question is avialible dedicated Forum , see link below  http://social.msdn.microsoft.com/Forums/it-IT/isvvba/threads

    Best Regards.


    Tuesday, March 20, 2012 8:30 PM
  • Thanks for the advice and heads-up. I appreciate it!
    Tuesday, March 20, 2012 8:34 PM
  • Thanks for the advice and heads-up. I appreciate it!
    Tuesday, March 20, 2012 8:34 PM