Generating dynamic charts based on the user input

[shivan4u]

Hi folks

I have a problem in making a chart with Excel, it would be great i
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 th
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 d

this functionality.

Regards
Siv

 

[Spreadsheet Solutions]

Shivan;

Could this help ?

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

 

[Tushar Mehta]

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

--
Regards,

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

 

[shivan4u]

Thankyou very much Mark, it was very much helpfull

Regards
Siva

 

[shivan4u]

Thankyou very much Tushar, it was very much helpfull.

Regards
Siva