software

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: www.excelforum.com/member.php...oamp;userid=31484
View this thread: www.excelforum.com/showthread...hreadid=511610Shivan;

Could this help ?

www.rosenkrantz.nl/charttip02.htm--
Mark Rosenkrantz
---
Spreadsheet Solutions
Witkopeend 24
1423 SN
Uithoorn, Netherlands
---
E:
W: www.rosenkrantz.nlquot;shivan4uquot; gt; wrote in
message ...
gt;
gt; Hi folks
gt;
gt; I have a problem in making a chart with Excel, it would be great if
gt; anyone
gt; can help me in doing this.
gt;
gt; Here it is, the first sheet is going to have a combo box
gt; with a graph below that and the values for the graph comes from the
gt; second
gt; sheet.
gt;
gt; when the user is going to choose different values from the combo box,
gt; the
gt; graph automatically changes depending upon those values.
gt;
gt; It would be great if I could have the Macro sample which is going to do
gt;
gt; this functionality.
gt;
gt; Regards
gt; Siva
gt;
gt;
gt; --
gt; shivan4u
gt; ------------------------------------------------------------------------
gt; shivan4u's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31484
gt; View this thread: www.excelforum.com/showthread...hreadid=511610
gt;
No need for code. See
Dynamic Charts
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 gt;,says...
gt;
gt; Hi folks
gt;
gt; I have a problem in making a chart with Excel, it would be great if
gt; anyone
gt; can help me in doing this.
gt;
gt; Here it is, the first sheet is going to have a combo box
gt; with a graph below that and the values for the graph comes from the
gt; second
gt; sheet.
gt;
gt; when the user is going to choose different values from the combo box,
gt; the
gt; graph automatically changes depending upon those values.
gt;
gt; It would be great if I could have the Macro sample which is going to do
gt;
gt; this functionality.
gt;
gt; Regards
gt; Siva
gt;
gt;
gt; --
gt; shivan4u
gt; ------------------------------------------------------------------------
gt; shivan4u's Profile: www.excelforum.com/member.php...oamp;userid=31484
gt; View this thread: www.excelforum.com/showthread...hreadid=511610
gt;
gt;


Thankyou very much Mark, it was very much helpfull

Regards
SivaSpreadsheet Solutions Wrote:
gt; Shivan;
gt;
gt; Could this help ?
gt;
gt; www.rosenkrantz.nl/charttip02.htm
gt;
gt;
gt; --
gt; Mark Rosenkrantz
gt; ---
gt; Spreadsheet Solutions
gt; Witkopeend 24
gt; 1423 SN
gt; Uithoorn, Netherlands
gt; ---
gt; E:
gt; W: www.rosenkrantz.nl
gt;
gt;
gt; quot;shivan4uquot; gt;
gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hi folks
gt; gt;
gt; gt; I have a problem in making a chart with Excel, it would be great if
gt; gt; anyone
gt; gt; can help me in doing this.
gt; gt;
gt; gt; Here it is, the first sheet is going to have a combo box
gt; gt; with a graph below that and the values for the graph comes from the
gt; gt; second
gt; gt; sheet.
gt; gt;
gt; gt; when the user is going to choose different values from the combo
gt; box,
gt; gt; the
gt; gt; graph automatically changes depending upon those values.
gt; gt;
gt; gt; It would be great if I could have the Macro sample which is going to
gt; do
gt; gt;
gt; gt; this functionality.
gt; gt;
gt; gt; Regards
gt; gt; Siva
gt; gt;
gt; gt;
gt; gt; --
gt; gt; shivan4u
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; shivan4u's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31484
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=511610
gt; gt;--
shivan4u
------------------------------------------------------------------------
shivan4u's Profile: www.excelforum.com/member.php...oamp;userid=31484
View this thread: www.excelforum.com/showthread...hreadid=511610
Thankyou very much Tushar, it was very much helpfull.

Regards
Siva

Tushar Mehta Wrote:
gt; No need for code. See
gt; Dynamic Charts
gt; www.tushar-mehta.com/excel/ne...rts/index.html
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt; gt;
gt; gt; Hi folks
gt; gt;
gt; gt; I have a problem in making a chart with Excel, it would be great if
gt; gt; anyone
gt; gt; can help me in doing this.
gt; gt;
gt; gt; Here it is, the first sheet is going to have a combo box
gt; gt; with a graph below that and the values for the graph comes from the
gt; gt; second
gt; gt; sheet.
gt; gt;
gt; gt; when the user is going to choose different values from the combo
gt; box,
gt; gt; the
gt; gt; graph automatically changes depending upon those values.
gt; gt;
gt; gt; It would be great if I could have the Macro sample which is going to
gt; do
gt; gt;
gt; gt; this functionality.
gt; gt;
gt; gt; Regards
gt; gt; Siva
gt; gt;
gt; gt;
gt; gt; --
gt; gt; shivan4u
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; shivan4u's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31484
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=511610
gt; gt;
gt; gt;--
shivan4u
------------------------------------------------------------------------
shivan4u's Profile: www.excelforum.com/member.php...oamp;userid=31484
View this thread: www.excelforum.com/showthread...hreadid=511610