+ Reply to Thread
Results 1 to 5 of 5

Generating dynamic charts based on the user input

  1. #1
    Registered User
    Join Date
    02-13-2006
    Posts
    3

    Generating dynamic charts based on the user input

    Hi folks

    I have a problem in making a chart with Excel, it would be great if anyone
    can help me in doing this.

    Here it is, the first sheet is going to have a combo box
    with a graph below that and the values for the graph comes from the second
    sheet.

    when the user is going to choose different values from the combo box, the
    graph automatically changes depending upon those values.

    It would be great if I could have the Macro sample which is going to do
    this functionality.

    Regards
    Siva

  2. #2
    Spreadsheet Solutions
    Guest

    Re: Generating dynamic charts based on the user input

    Shivan;

    Could this help ?

    http://www.rosenkrantz.nl/charttip02.htm


    --
    Mark Rosenkrantz
    ---
    Spreadsheet Solutions
    Witkopeend 24
    1423 SN
    Uithoorn, Netherlands
    ---
    E: contact@rosenkrantz.nl
    W: www.rosenkrantz.nl


    "shivan4u" <shivan4u.235mey_1139811300.8572@excelforum-nospam.com> wrote in
    message news:shivan4u.235mey_1139811300.8572@excelforum-nospam.com...
    >
    > Hi folks
    >
    > I have a problem in making a chart with Excel, it would be great if
    > anyone
    > can help me in doing this.
    >
    > Here it is, the first sheet is going to have a combo box
    > with a graph below that and the values for the graph comes from the
    > second
    > sheet.
    >
    > when the user is going to choose different values from the combo box,
    > the
    > graph automatically changes depending upon those values.
    >
    > It would be great if I could have the Macro sample which is going to do
    >
    > this functionality.
    >
    > Regards
    > Siva
    >
    >
    > --
    > shivan4u
    > ------------------------------------------------------------------------
    > shivan4u's Profile:
    > http://www.excelforum.com/member.php...o&userid=31484
    > View this thread: http://www.excelforum.com/showthread...hreadid=511610
    >




  3. #3
    Tushar Mehta
    Guest

    Re: Generating dynamic charts based on the user input

    No need for code. See
    Dynamic Charts
    http://www.tushar-mehta.com/excel/ne...rts/index.html

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <shivan4u.235mey_1139811300.8572@excelforum-nospam.com>,
    shivan4u.235mey_1139811300.8572@excelforum-nospam.com says...
    >
    > Hi folks
    >
    > I have a problem in making a chart with Excel, it would be great if
    > anyone
    > can help me in doing this.
    >
    > Here it is, the first sheet is going to have a combo box
    > with a graph below that and the values for the graph comes from the
    > second
    > sheet.
    >
    > when the user is going to choose different values from the combo box,
    > the
    > graph automatically changes depending upon those values.
    >
    > It would be great if I could have the Macro sample which is going to do
    >
    > this functionality.
    >
    > Regards
    > Siva
    >
    >
    > --
    > shivan4u
    > ------------------------------------------------------------------------
    > shivan4u's Profile: http://www.excelforum.com/member.php...o&userid=31484
    > View this thread: http://www.excelforum.com/showthread...hreadid=511610
    >
    >


  4. #4
    Registered User
    Join Date
    02-13-2006
    Posts
    3
    Thankyou very much Mark, it was very much helpfull

    Regards
    Siva


    Quote Originally Posted by Spreadsheet Solutions
    Shivan;

    Could this help ?

    http://www.rosenkrantz.nl/charttip02.htm


    --
    Mark Rosenkrantz
    ---
    Spreadsheet Solutions
    Witkopeend 24
    1423 SN
    Uithoorn, Netherlands
    ---
    E: contact@rosenkrantz.nl
    W: www.rosenkrantz.nl


    "shivan4u" <shivan4u.235mey_1139811300.8572@excelforum-nospam.com> wrote in
    message news:shivan4u.235mey_1139811300.8572@excelforum-nospam.com...
    >
    > Hi folks
    >
    > I have a problem in making a chart with Excel, it would be great if
    > anyone
    > can help me in doing this.
    >
    > Here it is, the first sheet is going to have a combo box
    > with a graph below that and the values for the graph comes from the
    > second
    > sheet.
    >
    > when the user is going to choose different values from the combo box,
    > the
    > graph automatically changes depending upon those values.
    >
    > It would be great if I could have the Macro sample which is going to do
    >
    > this functionality.
    >
    > Regards
    > Siva
    >
    >
    > --
    > shivan4u
    > ------------------------------------------------------------------------
    > shivan4u's Profile:
    > http://www.excelforum.com/member.php...o&userid=31484
    > View this thread: http://www.excelforum.com/showthread...hreadid=511610
    >

  5. #5
    Registered User
    Join Date
    02-13-2006
    Posts
    3
    Thankyou very much Tushar, it was very much helpfull.

    Regards
    Siva

    Quote Originally Posted by Tushar Mehta
    No need for code. See
    Dynamic Charts
    http://www.tushar-mehta.com/excel/ne...rts/index.html

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <shivan4u.235mey_1139811300.8572@excelforum-nospam.com>,
    shivan4u.235mey_1139811300.8572@excelforum-nospam.com says...
    >
    > Hi folks
    >
    > I have a problem in making a chart with Excel, it would be great if
    > anyone
    > can help me in doing this.
    >
    > Here it is, the first sheet is going to have a combo box
    > with a graph below that and the values for the graph comes from the
    > second
    > sheet.
    >
    > when the user is going to choose different values from the combo box,
    > the
    > graph automatically changes depending upon those values.
    >
    > It would be great if I could have the Macro sample which is going to do
    >
    > this functionality.
    >
    > Regards
    > Siva
    >
    >
    > --
    > shivan4u
    > ------------------------------------------------------------------------
    > shivan4u's Profile: http://www.excelforum.com/member.php...o&userid=31484
    > View this thread: http://www.excelforum.com/showthread...hreadid=511610
    >
    >

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1