If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple specific records based on user input on the form. | Senexis | Using Forms | 3 | January 22nd, 2006 02:07 PM |
Have a specific form open based on user/ Is this possible? | jernatety | Using Forms | 1 | August 16th, 2005 03:32 PM |
How do you use check boxes in user input fields for queries | Jamil Afza | General Discussion | 2 | June 22nd, 2005 03:40 PM |
Making a report that can leave records blank based on user input. | Billy | Setting Up & Running Reports | 3 | June 20th, 2005 12:46 PM |
Two versions again-language issue | Otto | Setup, Installing & Configuration | 3 | May 28th, 2004 04:57 AM |