|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 01:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com