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

Shivan;

Could this help ?

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


--
Mark Rosenkrantz
---
Spreadsheet Solutions
Witkopeend 24
1423 SN
Uithoorn, Netherlands
---
E: [email protected]
W: www.rosenkrantz.nl


"shivan4u" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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 <[email protected]>,
[email protected] 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
>
>

Thankyou very much Mark, it was very much helpfull

Regards
Siva

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: [email protected]
W: www.rosenkrantz.nl


"shivan4u" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thankyou very much Tushar, it was very much helpfull.

Regards
Siva

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 <[email protected]>,
[email protected] 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
>
>