Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Feb 2006
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graph Goals (2003)

    I need to create a chart in Excel that will have line graphs based on a reps dollar amount per months. Plus I need to be able to have someone enter a percentage of increase, and based on the percentage, create another line graph showing the goal on the fly. Can someone help me as to how I would do this in VBA.

    Thanks,
    Chris

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Goals (2003)

    Could you provide a small example of what you want the result to be, with a clear explanation?

  3. #3
    Lounger
    Join Date
    Feb 2006
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Goals (2003)

    Hi Hans,

    Enclosed is an example of what I am looking for.

    Thanks for your help.

    Chris

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Goals (2003)

    You mentioned a percentage of increase. I can't discover such a percentage in the example you posted. Could you please explain? Thank you.

  5. #5
    Lounger
    Join Date
    Feb 2006
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Goals (2003)

    The user should be able to enter a percentage increase from 0 to 100 in an input box that will appear once the Goals command button is pressed.. Then with VBA create a graph line showing the percentage increase in dollar amount. In my example, series 2 graph line, would be the percentage increase in dollar amount. The increase will be from January until the last month showing on the chart. So for this month the graph will show January and February on the x line, and at the end of next month it will show January, February, and March on the x line, and so on. I hope this helps you.

    Thank you for your help.
    Chris

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Goals (2003)

    I don't think you need VBA for this, you can let the user enter the percentage in a cell, and the chart will be updated automatically. See attached version.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •