| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 -- shivan4u ------------------------------------------------------------------------ shivan4u's Profile: http://www.excelforum.com/member.php...o&userid=31484 View this thread: http://www.excelforum.com/showthread...hreadid=511610 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Generating dynamic charts based on the user input
Thankyou very much Mark, it was very much helpfull Regards Siva Spreadsheet Solutions Wrote: 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 -- shivan4u ------------------------------------------------------------------------ shivan4u's Profile: http://www.excelforum.com/member.php...o&userid=31484 View this thread: http://www.excelforum.com/showthread...hreadid=511610 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Generating dynamic charts based on the user input
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| of Named Ranges, Dynamic Charts and scroll bars... | Charts and Charting in Excel | |||
| a question regarding dynamic ranges and charts | Charts and Charting in Excel | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| Dynamic Charts | Excel Discussion (Misc queries) | |||
| Can I post dynamic line charts by swapping out .cvs files??? | Charts and Charting in Excel | |||
Linear Mode
