Thankyou very much Tushar, it was very much helpfull.

Regards
Siva

Tushar Mehta Wrote:
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 ,
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




--
shivan4u
------------------------------------------------------------------------
shivan4u's Profile: http://www.excelforum.com/member.php...o&userid=31484
View this thread: http://www.excelforum.com/showthread...hreadid=511610