View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Spreadsheet Solutions
 
Posts: n/a
Default 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:
W:
www.rosenkrantz.nl


"shivan4u" wrote in
message ...

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